Update DATETIME Row

[ShoeLace1291]

How do I update a DATETIME table row?  What would the value for $datetime be?

 

 

$query = mysql_query("INSERT INTO news(headline,message,posterID,datetime)

values('$headline', '$message', '$posterid', '$datetime')") or die("Error: ".mysql_error());

[MadTechie]

Depends on the datatype

 

try

$datetime  = now();

assuming you want the current date/time..

 

re-phrase the question

[taith]

or $datetime=time();

[ShoeLace1291]

Niether of those worked.  now() just gave me an unkown function error and time() didn't update it at all.

[MadTechie]

OK.. so whats the field's datatype ?

 

please look in my signature for how to ask a question!

[ShoeLace1291]

The field data type is DATE.

[MadTechie]

atleast one of these should work!!

 

CURDATE();

CURRENT_DATE();

NOW();

 

you may want to post your tests!