Yes that works.....me newbie php skills falling down again...;0)
-----Original Message----- From: Wee Keat (VisualDensity] [mailto:[EMAIL PROTECTED]] 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." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php