zerofill

[[deleted]]

I have an int(8) zerofill field in a table.

When I retrieve this value from the database and output it to the screen, it doesn't show the zeros. 00012345 becomes 12345. Is there any way to force a PHP variable to be a string and not an integer? I know that I can reformat the string afterwards but I'd rather the value (which the database query outputs as 00012345) be accepted as a string in the first place.

Suggestions?

[devinemke]

strange. i just did a test on a table with an INT(8) UNSIGNED ZEROFILL field.

$result = mysql_query('SELECT number FROM test') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {echo $row['number'] . '<br>';}

and the output was as expected:

00000001
00000002
00000003
00000004
00000005
00000006
00000007
etc...

my box:
WinXP
Apache 2.0.50
mySQL 4.1.10a
PHP 5.0.4