DATETIME and HTTP_USER_AGENT

[dekuro]

How do I insert both into a mySQL table with the help of PHP?

INSERT INTO table (date,user_agent) VALUES (DATETIME(), HTTP_USER_AGENT)

doesn't work... replacing 'DATETIME' by 'DATE' doesn't work either.

[KeithMcL]

Well i'm only new to PHP so no laughing if this is wrong

What about replacing DATETIME is CURDATE() ??

rgds,

[dekuro]

Uhh.. yes, partly. Now only the time is missing (00:00:00)

now it appears like this: 2000-10-06 00:00:00

[oodie]

Keith is right, if you want to insert current date you can use CURDATE() or NOW() (if your field type is DATETIME, NOW() will also insert current time in the format "yyyy-mm-dd hh:mm:ss"). For user agent, since you use PHP to insert data, you should use $HTTP_USER_AGENT (it's a PHP variable). Your query will be like this :

$query = "INSERT INTO table (date,user_agent) VALUES (CURDATE(), '". $HTTP_USER_AGENT. "')";

[dekuro]

Wow! Wonderful It works just perfectly.