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/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to