The suggestions made are all great. However, I have a problem understanding the requirement of having the Id in the database matchup with the filename. (You could always append the when binding the database Id with the filename.) Please elaborate on your requirements. Thanks. On 12/15/05, Jim Moseby <JMoseby@xxxxxxxxxxxxxxxxx> wrote: > > > > > I'm looking into the ZEROFILL option now. Didn't know about > > it before but it > > looks promising and probably is my solution. I'll get back. > > Obviously, with a 4 digit id, you will only be able to store 10,000 > records. > If I recall correctly, MySQL auto-increment fields will not reuse id's > when > they are deleted. So, you will need to take that into consideration when > (if) you reach the 9,999th record. > > JM > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Anas Mughal