Timis Posted September 9, 2002 Share Posted September 9, 2002 While I have tested my shop I added some test costomers and orders.Even if i delete them from the admin section, there ID are still present in my database.Is there a way to count the ID of the customers and the orders from zero?At this moment the next customer who'll join my shop will the the ID number 22 instead of 1.Any ideas? Link to comment Share on other sites More sharing options...
Mark Evans Posted September 9, 2002 Share Posted September 9, 2002 there a way to count the ID of the customers and the orders from zero? To reset the auto_increment counter for a column, perform the following sql query in phpmyadmin ALTER TABLE customers AUTO_INCREMENT = 1 Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds) Link to comment Share on other sites More sharing options...
Timis Posted September 9, 2002 Author Share Posted September 9, 2002 Thanks for your help Sparky :D Link to comment Share on other sites More sharing options...
darkvader Posted December 6, 2004 Share Posted December 6, 2004 To reset the auto_increment counter for a column, perform the following sql query in phpmyadmin ALTER TABLE customers AUTO_INCREMENT = 1 <{POST_SNAPBACK}> Will this same concept apply to increment the Orders number. For example if I want the next order number to be 1000, will it work?\ thanks for the help in advance Link to comment Share on other sites More sharing options...
boxtel Posted December 6, 2004 Share Posted December 6, 2004 Will this same concept apply to increment the Orders number. For example if I want the next order number to be 1000, will it work?\thanks for the help in advance <{POST_SNAPBACK}> yes Treasurer MFC Link to comment Share on other sites More sharing options...
gregy Posted December 30, 2004 Share Posted December 30, 2004 just to be sure myself ... ALTER TABLE orders AUTO_INCREMENT = 1 should reset Orders numbers to 1? thanx Link to comment Share on other sites More sharing options...
darkvader Posted January 11, 2005 Share Posted January 11, 2005 just to be sure myself ... ALTER TABLE orders AUTO_INCREMENT = 1 should reset Orders numbers to 1? thanx <{POST_SNAPBACK}> Yes you got it right :thumbsup: Link to comment Share on other sites More sharing options...
dswofford Posted July 13, 2005 Share Posted July 13, 2005 Yes you got it right :thumbsup: <{POST_SNAPBACK}> I tried this and now my site says Parse error: parse error in C:\Domains\ryford.com\wwwroot\admin\orders.php on line 81 if I try to see an order on line 81 it says case 'deleteconfirm': Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.