add date & time, is this correct?

[ok]

i'm trying to insert date & time.

 

i tried this below

$query = "INSERT INTO contest (date, time) VALUES ('.curdate().', '.curtime().')";

 

but i fail.

 

what is the correct syntax?

 

thank you.

 

 

 

[JasonLewis]

You are using " but you break out with '. Try this:

 

$query = "INSERT INTO contest (date, time) VALUES (".curdate().", ".curtime().")"; 
$run = mysql_query($query) or die(mysql_error());

 

Make sure you have defined the functions curdate() and curtime().

 

Note: If you make the MySQL field a DATETIME you can have both the date and time in the same column, instead of having 2 (one date and one time).

[PFMaBiSmAd]

curdate() and curtime() are mysql functions and should be used directly in the query without any php concatenation dots. They return a string and do not require single-quotes around them.

 

$query = "INSERT INTO contest (date, time) VALUES (curdate(),curtime())";

 

And since there is probably no reason to separate the date and time, if you change to a single DATETIME field, just use now() -

 

$query = "INSERT INTO contest (your_datetime_field) VALUES (now())";

[JasonLewis]

Thanks for that one PFMaBiSmAd.

I knew of now(), but not of curdate() and curtime().