hi , i am develop a site, my database have data, when i delete all data and insert new data the auto_increment field continue with the old value ( befor delete) so , how can i use alert command via php . thanks , zuhear "John W. Holmes" <holmes072000@charter.net> wrote in message 000a01c31279$dd6f5670$7c02a8c0@coconut">news:000a01c31279$dd6f5670$7c02a8c0@coconut... > > how i can reset value of auto_increment field > > Recreate your table or use the ALTER command. Why do you need to do > this? > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php