[SOLVED] mysql_insert_id with zerofill?

[phpknight]

Is there a way to get mysql_insert_id function to return the value with the padding zeros?  I am using bigint.  Even though I format it explicitly as a strong upon return, it still leaves out the zeros up front.  Any ideas?

[phpknight]

I am temporarily doing this by writing my own zerofill function, but there should be something better out there.

[fenway]

LPAD()?

[Barand]

or

<?php
$num = 42;
$padded = sprintf('%08d', $num);    // 00000042
?>

[phpknight]

I cannot find the LPAD function.  About the sprintf, I was hoping there was actually a function call for it that is like mysql_insert_id() but returns a padded number.  The problem is it is truncating my zerofill.  I have it working now, so it is no big deal, but it threw me at first.

[fenway]

I cannot find the LPAD function.

 

Because you're looking in php, not mysql.

 

And no, there is a function for this... LPAD().

[phpknight]

Okay, thanks!