Rahul, Rahul S. Johari wrote: > The 4 Digit ID (beginning from 0001) will be used in two places: > (a) It will be the ID for the record in the mySQL table, instead of the > usual ID that we create in mySQL. It will be a Primary Key, Not Null, > Auto_Increment Adding ZEROFILL to that definition might be what you're after. Cheers, David -- David Grant http://www.grant.org.uk/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php