RE: [PHP] mmmmm SELECT

Yes that works.....me newbie php skills falling down again...;0) -----Original Message----- From: Wee Keat (VisualDensity] [mailto:weekeat@visualdensity.com] Sent: Tuesday, January 07, 2003 10:25 AM To: Bruce Levick Subject: Re: [PHP] mmmmm SELECT >#################################################### >$query_retrievetasks = "SELECT * FROM tasks, users WHERE tasks.UID = >users.User_id AND active="yes" ORDER by tasks.ID"; >#################################################### >Can't understand this, is it just something simple I am missing?? Try using single quote instead of double quote... like this $query_retrievetasks = "SELECT * FROM tasks, users WHERE tasks.UID = users.User_id AND active='yes' ORDER by tasks.ID"; Not too sure myself... but it's just a wild guess... Hope this helps! Yours, Wee Keat ------------------------------------------------------------ "Good timber does not grow with ease; the stronger the wind, the stronger the trees."