Format Number

[Dysan]

How do I start an auto number at 000001 instead of just 1?

[Dysan]

How do I format a number field to display 000001 instead of just 1?

[NogDog]

[man]sprintf/man or [man]printf/man, e.g.:

<?php
$test = 2;
printf('%06d', $test);

[dagon]

000001 is 1, i assume where talking about a db field, you will have to add the leading 0's on the output.

have you considered

ALTER TABLE foo AUTO_INCREMENT =100000

instead

[bradgrafelman]

NOTE: Please don't create several threads for related (or, in this case, the same) topics. I've merged your two threads that deal with the same issue.

The auto increment in a database should normally be considered DB-only, that is, you shouldn't depend on it for display purposes as its only a way for the DB to identify a specific row.

As dagon noted, the best solution would be to simply use some functions to adapt the ID number for your display purposes - NogDog's code above shows you how.