ok i have this table that is and one of the fields is has auto_increment. The database type is MyISAM. I use phpmyadmin to work with mysql a lot. when i go in and add another row of data the auto_index automatically assigns something way off..and right now its using 8,388,607. my latest record is 103. Now in a webpage when i add data it works correctly. I changed the database to ISAM and in phpmyadmin it works correctly. Ok i'm really confused here. all my other tables work fine, and i've used 2 different versions of phpMyAdmin and it does the same thing. Does anybody know what is wrong?
peace
sean
peace
sean