How to change client ID?

[hostlonestar]

Basically, what I want to do, is change where my clients start getting their numbers. Instead of 1,2,3,4, etc. I want to change it to say 100, 101, 102, etc. Does anyone know how to do this? Thanks in advance.

[Matt Wade]

Issue this SQL statement:

 

ALTER TABLE tblclients AUTO_INCREMENT = 100;

 

Please understand that I have tested this, but it should work. I wash my hands of any responsibility however .

[hostlonestar]

lol does anyone have anything that has been tested? Where do I put this in? My knowledge of PHP is limited at best. I can look at something and halfway figure out what is going on, but the actual act of coding it....thats a work in progress.

[Matt Wade]

That's an SQL statement. You run it against the database. No PHP is required.

[sparky]

Use phpmyadmin to run the sql above

Edited January 29, 2009 by sparky

[Matt Wade]

config => General Setings => Invoices tab => Invoice Starting #

 

 

That's the invoice #. He's asking about client id.