Are you deleting them one by one? If you set a condition for the deleting, then the auto_increment value won't go back to zero, but if you just delete all it will. For example, if you say: delete from my_table where 1>0; it won't reset the value. But if you just say: delete from my_table; it should reset the value to zero. -Angela -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]