Posted by Michael Fesser on 10/18/07 19:06

..oO(WebSnozz)

>I am losing the leading zeros when I get autoincrement IDs from a
>column with ZEROFILL enabled.

I wouldn't rely on that.

>I would like to have the leading
>zeros. I have tried both the php function last_insert_id as well as
>running a SELECT query and using the result. I am getting the correct
>id, it is just losing the leading zeros. I have doulbe checked the
>table in the database, and it does have the leading zeros. Thanks for
>any help.

Just store normal integers and add the leading zeros when you really
need them, for example with sprintf() in your script

Micha

• Next in forum: Using PHP to send a fax?
• Prev in forum: LAST_INSERT_ID with ZEROFILL
• Thread view: Re: LAST_INSERT_ID with ZEROFILL

[Reply to this message]