Member Avatar

Good day all:

I have a mysql insert statement inserting data to db. The value of one of the variables is:

' $_POST[servicedesc]')

I want to be able to append the current date and time in front of this value and then insert into the db. This value will be inserted into a text field so I would like to have the date and time on a line different than the value.

Any thoughts on this!
Mossa

Edited by mbarandao: n/a
Member Avatar 

$time = mysql_fetch_array(mysql_query("select now()"));
echo $time['now()'];

You can use the $time variable to add the current server time.

Member Avatar

Problem resolved!

Thank you all that posted replies. Here is the solution that is working for me based on my initial post --hope it helps someone else!

CONCAT(NOW(), '\n\n' '$_POST[servicedesc]','\n\n----End of Service Report---'))";

The very best!
Mossa