Re: Bizzare error
| From: | shaun | Date: | Tue, 22 Apr 2003 15:10:52 +0000 |
| Subject: | Re: Bizzare error | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144836@lists.php.net to get a copy of this message | ||
"Jason Wong" <php-general@gremlins.biz> wrote in message
news:200304222306.57486.php-general@gremlins.biz...
> On Tuesday 22 April 2003 22:31, shaun wrote:
>
> Please use a descriptive subject. Also this type of question belongs to
the
> php-db list.
>
> > > > echo "query = $query<br>";
> > > > $result = mysql_query($query);
> > >
> > > to see the error message do this:
> > > $result = mysql_query($query) or die ('Query failed, MySQL says:
> > > '.mysql_error().' in '.__FILE__.' line '.__LINE__)
>
> You said it worked ok at the mysql commandline, presumably you used the
exact
> value of $query as above? What does $query look like?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> ------------------------------------------
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-general
> ------------------------------------------
> /*
> The inherent vice of capitalism is the unequal sharing of blessings;
> the inherent virtue of socialism is the equal sharing of misery.
> -- Churchill
> */
>
Here is my output:
query = SELECT A.*, B.*, U.User_ID FROM WMS_Allocations A, WMS_Bookings B,
WMS_User U, WMS_Projects P WHERE A.User_ID = B.User_ID AND A.User_ID = '1'
AND B.Booking_Start_Date >= '2003-4-28' AND B.Booking_End_Date <=
'2003-04-29'
num = 0