On Thu, 18 Oct 2007 18:45:25 +0000, WebSnozz wrote:
Quote:
I am losing the leading zeros when I get autoincrement IDs from a
column with ZEROFILL enabled. 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.
>
$result = mysql_query($insertQuery);
if($result)
{
//$uniqueFilenameResult = mysql_insert_id($link).$uploadFilename;
$insertIDResult = mysql_query("SELECT LAST_INSERT_ID()");
if($insertIDResult)
{
$nrows = mysql_num_rows($insertIDResult);
$rows = mysql_fetch_row($insertIDResult);
$uniqueFilenameResult = $rows[0].$filename;
}
}
You can use str_pad() to fill it back out.
$insertIDResult = mysql_query("SELECT LAST_INSERT_ID()");
$insertIDResult = str_pad($insertIDResult, N, "0", STR_PAD_LEFT);
Where N is the desired length of the string.
--
Kelsey Sigurdur