[SOLVED] insert DATETIME help

[MDanz]

when i check the database in the DATETIME field it has  0000-00-00 00:00:00

 

heres how i insert into db, the field posted is DATETIME type.  everytime i check a new record it has the value 0000-00-00 00:00:00. when it should say the current date and time.

 

      $query = "INSERT INTO Stacks";
      $query .= "(`username`,`hyperlink`,`name`,`summary`,`info`,`keywords`,`posted`) VALUES ('$username','$hyperlink','$name','$summary','$info','$keywords','NOW()')";

[PFMaBiSmAd]

Strings have single-quotes around them. NOW() is not a string, it is a mysql function. Remove the single-quotes from around it.