This should work :
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,Now())";
Xavier
-----Message d'origine-----
De : Alia Mikati [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 19 avril 2002 11:28
À : [EMAIL PROTECTED]
Objet : Date function
Hello
I have the following SQL and I wanna insert the current date in one of
the table fields but it's not working. Can u tell me whats the problem?
(I'm using mysql and php)
Thx a lot
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,date())";
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
