I've got a table called quotes and one of the columns has a field named datesent.
I set this column up as:
Field = datesent
Type = timestamp
Attributes = on update CURRENT_TIMESTAMP
Default = CURRENT_TIMESTAMP
When the form data is sent to the mysql db the datesent cell is populated with 2010-09-06 15:04:05 which is what I needed.
Now I'm trying to retrieve it, reformat it to 06-09-2010 15:04:05, and display it to user.
Is there anything like mysql_insert_id() which will enable me to retrieve the time stamp data rather than the last AI field or will I have to find another way wth php.
Any help or pointers would be a great help.