--- Brian E Boothe <[EMAIL PROTECTED]> wrote:
> hi all :
> i want to Autogenerate a Issue_id number everytime the Add issue page
> Comes up to add a Issue,, how could i do that Including the date like
> today would be
> 6132008 thanks
Speaking of dates, your computer clock seems to be off by a day or so.
If you didn't want to use the AUTO_INCREMENT feature I mentioned and really
wanted to have the date be part of the issue number, you could do so with the
date() function in PHP. I would suggest that using Year Month Day would allow
for easier sorting in chronological order.
You will want to consider how to handle multiple entries for a given day. In
DNS entries, a popular serial number scheme involves YYYYMMDDNN where NN is a
two digit number which is increased if there are multiple changes in a given
day.
$num = date("Ymd"); // 20080613
James