Re: Bizzare error

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. */