formatting query

[GhOnDiE]

hi all, im sure somebody can help on here.

im making a website that requires the id field to display 3 numbers ie 001,002,003 i have played around trying to work out how to do it by formatting the data then putting it into the database, however as im using the database as an int and it is auto incremement and primary key

how would i go about formatting the numeric text like that?

would it be a case of writing a script to add the 00's or can it be done server side by the mysql server?

i think that makes sense
thanks.

[448191]

Don't forget, php IS server-side.

Anyway, you could pad the id with zero's:
[sql]SELECT LPAD(`id`, 3-LENGTH(`id`), "0") FROM table[/sql]

[kenrbnsn]

You can also format the string when you output it:
[code]<?php
$strs = array(1,2,3);
foreach($strs as $str)
  printf("%03d<br>",$str)
?>[/code]

Ken