Re: 4 Digit ID with Leading Zeros

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux