MSQL and php creating problem with date..
| From: | Dhaval Desai | Date: | Sun, 14 Jan 2001 11:28:46 +0000 |
| Subject: | MSQL and php creating problem with date.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-34462@lists.php.net to get a copy of this message | ||
Hiee Guys I am trying to do the following: but I get
an error saying:
*****************************************************
You have an error in your SQL syntax near
'dayofmonth(date_add('', INTERVAL 7 DAY)))' at line 2
*****************************************************
<?php
$odate = date('Y m d');
$connect = mysql_connect("localhost");
$query = "insert into list(odate,edate)
values($odate,dayofmonth(date_add('$odate_sql',
INTERVAL 7 DAY))";
$execute = mysql_db_query("dubaiteenz",$query);
if($execute)
{
echo "Success, you are thinking in the right
direction";
}
else
{
echo mysql_error();
}
?>
Can anybody help me out please....
Thanx!
Dhaval Desai
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/