On 12/15/05, Rahul S. Johari <[EMAIL PROTECTED]> wrote:
> Ave,
>
> I want to assign a 4 Digit ID with leading zeros to each record added using
> a form I have created.
>
> The PHP scripts does two things:
> (a) It adds the data to a mySQL table
> (b) it generates a CSV file with the data
>
> 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
> (b) It will also be the filename for the CSV file.
>
> So basically it has to match the record adding in the mySQL table and the
> filename for the CSV.
Salve,
(a) It won't make a blind bit of difference to MySQL whether you have
leading zeros or not. It gets stored the same way.
(b) If you want to *display* the ID with 4 digits or generate a
filename in that format, use sprintf('%04d', $ID);
-robin
