Re: Is there an error??
| From: | Hrishi | Date: | Sun, 14 Jan 2001 13:03:27 +0000 |
| Subject: | Re: Is there an error?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-34467@lists.php.net to get a copy of this message | ||
$odate_sql is not initialized.
-------------------------------------------
Yeah, there are more important things in life than money, but they won't go
out with you if you don't have any.
----- Original Message -----
From: "Dhaval Desai" <dhaval_adams@yahoo.com>
To: "Hrishi" <hrishi@mediaibc.com>
Sent: Sunday, January 14, 2001 4:59 PM
Subject: Is there an error??
> 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/
>
>
>