How can I reset autonumber fields after i have emtied a table, so I can start with a clean database after testing it.

instead of deleting rows, use truncate tablename, this resets the auto_increment

ALTER TABLE `database_name`.`table_name` AUTO_INCREMENT = ##;

This will allow you to reset the starting point on your autoincrement. I had it set to auto, but a php page I made had somehow set it to 8000. So sometimes it is beneficial to be able to reset things back down to where they are logical.