Jump to content
Updating IPB tonight Read more... ×

Archived

This topic is now archived and is closed to further replies.

GhOnDiE

formatting query

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.