Re: 4 Digit ID with Leading Zeros
| From: | Rahul S. Johari | Date: | Thu, 15 Dec 2005 16:57:52 +0000 |
| Subject: | Re: 4 Digit ID with Leading Zeros | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227478@lists.php.net to get a copy of this message | ||
Ave,
That Worked!!
That was the perfect solution. Everything is working just the way I wanted
it to work now. I'm using ZEROFILL in my mySQL table and pulling the ID to
generate the filename.
Thanks a TON!
On 12/15/05 10:17 AM, "David Grant" <david@grant.org.uk> wrote:
> 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
Rahul S. Johari
Coordinator, Internet & Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel: (518) 266-0909 x154
Fax: (518) 266-0909
Email: rahul@informed-sources.com
http://www.informed-sources.com