mysql shows 5 digit ID; 00001 using zerofill, php query displays 1 digit; 1

[greencoin]

I'm trying to query the database, return the 5 digit ID + 1 and echo it into a text field. I have it all working but I'm losing my zeros! MySQL shows 00001 but my page displays 1.

 

The ID is stored in MySQL as mediumint(5), unassigned zerofill.

The php query is as follows;

$query2 = mysql_query("SELECT MAX(iid+1) AS maximum FROM gc_prod_info") or die(mysql_error());

 

Do I need to change my query to SELECT MAX(iid+00001) ...?

 

Any advice is appreciated. Thanks ~Rich

[teng84]

my sql consider 00001 as 1 so get 1 as an output all the zero at the left ignored.

now to have the complete number of character use 10000

[greencoin]

so are you saying that my numeric sequence has to start @ 10001 instead of 00001? ~Rich

[Illusion]

try this

SELECT CAST(MAX(iid+1) AS VARCHAR) AS maximum FROM gc_prod_info

or

SELECT CAST(MAX(iid) AS VARCHAR)+1 AS maximum FROM gc_prod_info

but I am not sure..............

 

[kenrbnsn]

Use either the function sprintf() to format the string or printf() to print a formated string with a zero filled field.

 

<?php
$i = 1;
printf("%05d",$i);
?>

 

Ken

[greencoin]

try this

SELECT CAST(MAX(iid+1) AS VARCHAR) AS maximum FROM gc_prod_info

or

SELECT CAST(MAX(iid) AS VARCHAR)+1 AS maximum FROM gc_prod_info

but I am not sure..............

 

 

I'm not sure changing it to a VARCHAR will work as I'm pushing it back into MySQL as an INT when the form is submitted... ~Rich

[Illusion]

I'm not sure changing it to a VARCHAR will work as I'm pushing it back into MySQL as an INT when the form is submitted... ~Rich

You can submit it as an INT, no problem.