Posted 23 July 2006 - 07:58 PM
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
Posted 23 July 2006 - 08:07 PM
Anyway, you could pad the id with zero's:
SELECT LPAD(`id`, 3-LENGTH(`id`), "0") FROM table
Posted 23 July 2006 - 09:30 PM
<?php $strs = array(1,2,3); foreach($strs as $str) printf("%03d<br>",$str) ?>
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users