Jump to content


Photo

formatting query


  • Please log in to reply
2 replies to this topic

#1 GhOnDiE

GhOnDiE
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 23 July 2006 - 07:58 PM

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.



#2 448191

448191
  • Staff Alumni
  • Advanced Member
  • 3,545 posts
  • LocationNetherlands

Posted 23 July 2006 - 08:07 PM

Don't forget, php IS server-side.

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


#3 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 23 July 2006 - 09:30 PM

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

Ken




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users