Pulling date from mysql

[Jason]

I have a form which ads a technician service ticket into mysql.
The fields are

tech name
time spent
service
client name
etc...

I assumed that mysql was storing the date of each record added to the
database, and I could simply retrieve it later without adding a "date"
field to the entry form. Do I need to add a field for date to the
form, or can I retrieve this directly from the database?

Thanks,
Jason

[Aggro]

Re: Pulling date from mysql

Jason wrote:
[color=blue]
> I have a form which ads a technician service ticket into mysql.
> The fields are
>
> tech name
> time spent
> service
> client name
> etc...
>
> I assumed that mysql was storing the date of each record added to the
> database, and I could simply retrieve it later without adding a "date"
> field to the entry form. Do I need to add a field for date to the
> form, or can I retrieve this directly from the database?[/color]

You can get the current date from database using now() function, but you
can't get the creation date of a row if you don't have such a field in
your table.