[SOLVED] ID count type

[adzie]

Is there a way to make my id field which is auto increment start with 000001 and upwards as I can only get it to display the number 1 in the field?

 

Thanks in advance

[bubblegum.anarchy]

I do not quite understand - maybe set the column to zerofill.

[fenway]

Don't do that -- format it on output if you care, leave the DB column out of it.

[cmgmyr]

try this:

<?php 

$userid = 1;

echo fill($userid,6);

function fill($val,$properlen){
$i=0;
$l=strlen($val);
$properlen = $properlen - $l;
$tmpstr=$val;
while ($i<$properlen)
{
	$tmpstr="0$tmpstr";
	++$i;
}
return $tmpstr;
}

?>

[bubblegum.anarchy]

SELECT lpad(id, 6, 0) AS id FROM table;

[adzie]

count this as solved thankyou