Changes in Database

[Timis]

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?

[Mark Evans]

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

[Timis]

Thanks for your help Sparky :D

[darkvader]

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

[boxtel]

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

[gregy]

just to be sure myself ...

 

ALTER TABLE orders AUTO_INCREMENT = 1

 

should reset Orders numbers to 1?

 

thanx

[darkvader]

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:

[dswofford]

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':