Serge
03-15-2003, 01:07 PM
Ok I have this query setup in a script.
$query = "INSERT INTO article
(articleid,author,email,title,summary,body,comment id,adate) values
('NULL', '$author', '$email', '$title', '$summary', '$body', '$commentid', 'NOW()')";
The only problem I'm having with it is that the NOW() function isn't working it is just retruning the defult value. I have the field set up as a datetime field so could someone tell me what's wrong with my syntax
$query = "INSERT INTO article
(articleid,author,email,title,summary,body,comment id,adate) values
('NULL', '$author', '$email', '$title', '$summary', '$body', '$commentid', 'NOW()')";
The only problem I'm having with it is that the NOW() function isn't working it is just retruning the defult value. I have the field set up as a datetime field so could someone tell me what's wrong with my syntax