joined:July 13, 2010
I'm trying to echo out the date field from mysql db.
I set it up not by using anything in an INSERT statement but mysql functionality. I added a column called 'datesent' then set the field type as 'TIMESTAMP' with default value as 'CURRENT_TIMESTAMP'.
When I send the form now the 'datesent' cell is now populated with '2010-09-06 11:27:37' which was what I needed.
All I need to do with this date is echo it out as a confirmation. I use '$quoteid = mysql_insert_id()' to retrieve the 'quoteid' value which mysql populated and I was hoping there's an equivalent cmd to retrieve the 'datesent' value seeing as mysql populated that as well.
Or do I need to look at constructing a specific SELECT statement like 'SELECT DATE_FORMAT('THE_COLUMN_NAME', %M %d %Y) AS `formatted date` as I've seen on another post because I would rather display DDMMYYYY anyway.
And is there any security or performance issues because I'm not inserting the CURRENT DATE from the mysql INSERT statement which I've seen on another post, just using mysql as outlined above.
Any help or pointers please.