mysql_insert_id() ignores ZEROFILL. Why? - PHPBuilder Forums

PHP Help PHP Coding
mysql_insert_id() ignores ZEROFILL. Why?

AAnon
Jul 14, 2000
Post #1 Friday, July 14, 2000 9:11 AM

my auto_increment field is set to integer(6) zerofill.

and when i call the last inserted id via mysql_insert_id(), it gives me e.g. 5 whereas in db its 000005.

any ideas to tackle this???

thank you,
Daarius...

6 years later

Bbrendanr
Dec 20, 2006
Post #2 Wednesday, December 20, 2006 3:10 AM

$pad_number = str_pad($number, 6, "0", STR_PAD_LEFT);

Brendan
Website Design Victoria BC

NogDog
Dec 20, 2006
Post #3 Wednesday, December 20, 2006 4:14 AM

As to the "why", it's because mysql_insert_id() returns an integer, not a string.

Write a Reply...

mysql_insert_id() ignores ZEROFILL. Why?

Anon

my auto_increment field is set to integer(6) zerofill.

and when i call the last inserted id via mysql_insert_id(), it gives me e.g. 5 whereas in db its 000005.

any ideas to tackle this???

thank you,
Daarius...

brendanr

$pad_number = str_pad($number, 6, "0", STR_PAD_LEFT);

Brendan
Website Design Victoria BC

NogDog

As to the "why", it's because mysql_insert_id() returns an integer, not a string.