Auto Increment

[aleez]

How do I start the auto number value at 0000000001, then increment by 1 upon each record being added to the database.

Example.

Record 1 = 0000000001
Record 2 = 0000000002
Record 3 = 0000000003
Record 4 = 0000000004
Record 5 ...

I really need this..thanks..

[bradgrafelman]

(I've moved your post into its own thread - please don't hijack others' threads!)

aleez wrote:

I really need this

Do you? Are you sure? Or do you instead just need a normal auto_increment column, and then do something like this:

$row = mysql_fetch_assoc($result_set);

echo sprintf('%010s', $row['id']);

EDIT: Otherwise, the MySQL equivalent would be to define the column as INT(10) ZEROFILL.

[aleez]

yes..something similar like ur example.. actually i want to create that running number for every transaction. when i press ok button then php will generate that running number and store it into database..