Re: Bizzare error

This query works when i run it on my web server command line entry tool, which is where i am testing my web site. The spaces are for identifiers for each table, its a common SQL query. "Jason Wong" <php-general@gremlins.biz> wrote in message news:200304222318.02672.php-general@gremlins.biz... > On Tuesday 22 April 2003 23:10, shaun wrote: > > > 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 > > So does that above query work in the mysql commandline? > > And why do you have spaces, such as '... FROM WMS_Allocations A ...' ? > > -- > 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 > ------------------------------------------ > /* > You're growing out of some of your problems, but there are others that > you're growing into. > */ >