MySQL Question (Problem Solved)

[medicjoe95]

-- Problem Solved --

I use "ID"s for my tables, so when I need to pull from the table, like to get information, I can pull from the ID instead of the actual username. I don't know why, just always have lol.

Now, I need to have the ID be like:
0000000001

Instead of just 1

I usually do INT(10) primary, auto_increasement and all that fun stuff.

I jsut need to know how to set it up so either the table will automatically put the 0's, or so I can do so in my PHP script.

Usually, I will insert into the table without the ID feild, and it will automatically create it with the next number avalible.

If I do not get a reply pretty soon, like today with a good answer - I will just wait for a friend to get online.

[DaveMichaels]

Try using the ZEROFILL attribute.

[lilleman]

Hi,

You can set the ZEROFILL attribute of the column.

id INT(10) UNSIGNED ZEROFILL auto_increment PRIMARY KEY

Yours, Erik.

[medicjoe95]

Thanks for quick reply.

Sitepoint rocks xDD