Page 1 of 1

DATETIME ISSUE

Posted: Sun Jun 10, 2007 5:24 am
by Dilbert137
Dear All,

I'm having an issue while trying to put the NOW() code in the insert sql statement of my codes. The program does not recognize the NOW(). Can someone help me.

$ajouter="insert into guestbook(Name_User,Address_User,eMail_User,Url_User,Comments_User,Date_User) values('$name','$adresse','$email','$url','$commentaires',NOW())";

mysql_query($ajouter);


Date_User field is of type datetime

Thanks
Dilbert137

Posted: Sun Jun 10, 2007 5:27 am
by volka
The program does not recognize the NOW().
And instead does what? Symptoms?

Posted: Sun Jun 10, 2007 5:34 am
by Dilbert137
Volka It's solved it was a field which was not well named.

:roll:

Thanks