Append date to variable in mysql insert statement

Question

0

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

php

Edited 7 Years Ago by mbarandao: n/a

2

Contributors

2

Replies

3

Views

7 Years

Discussion Span

7 Years Ago

Last Post by mbarandao

This Question has been Answered

php

mahavir123 1 · Answer 1 · 2010-11-13T20:43:58+00:00

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

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

mbarandao · Answer 2 · 2010-11-14T04:57:33+00:00

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