I am using a php script where I am adding categories, and each category has a number (auto incrementing). I added 40 categories, and duplicated the one of them, and deleted the category instead of editing it and changing the name. My question now is how can I fix it so that the category list is in order ( 40, 41, 42) instead of category 40, 42..

I believe it has to do with this:

ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234

I know to change 'theTableInQuestion' to my table, but how to fix it for my case is what I need. I forget what will fix this.

Thank you guys!
Brian

Why does it matter??

Originally Posted by chrishirst

Why does it matter??

I guess not to worry then. I guess that's why some invoicing programs (for example), the first customer is usually 10000 instead of just 1. I'll leave it be for now I guess.

If your invoicing your best bet is to use the unique row id + customerid + the invoice number as this make reading the numbers better later ( to find out what invoice number it is.. )

For example:
TestCustomerId = 9919
Rowid = 1234
Invoice number = 2 ( this is the 2nd time we have invoiced them )

123499192

Makes it easy to see later... ( well thats how i do it and i know others do also. )


( Ignore me, I noticed this was used as an example... )