[SOLVED] 5-digit auto-increment ID

[ryanwood4]

This may be a fairly simple question, but I can't figure it out.

 

I have an auto-increment ID column, which counts up in single digits, i.e. 0,1,2,3,4...

 

How do I make it, so it counts up like this: 00001,00002,00003,00004...

 

Thanks.

[rhodesa]

you can't force it to have leading zeros in the DB...cus it's an integer and integers don't have leading zeros. but you can add the leading zeros when you display the number:

 

<?php
  $id = 5;
  print str_pad($id,5,'0',STR_PAD_LEFT);
  //or
  printf('%05d',$id);
?>

[PFMaBiSmAd]

Or start with 10001, 10002, ...

[ryanwood4]

How do I force it to start at 10001

[gassaz]

Try Using ZeroFill...

 

example:

`id` int(5) unsigned zerofill NOT NULL auto_increment

[ryanwood4]

That worked a treat!

 

Thanks.