[PHP] mmmmm SELECT

2003-01-06 Thread Bruce Levick
I have this silly problem. This select query works fine. $query_retrievetasks = SELECT * FROM tasks, users WHERE tasks.UID = users.User_id ORDER by tasks.ID; But when I add a further

Re: [PHP] mmmmm SELECT

2003-01-06 Thread Steve Edberg
At 04:27 PM 1/6/03 , Bruce Levick wrote: I have this silly problem. This select query works fine. $query_retrievetasks = SELECT * FROM tasks, users WHERE tasks.UID = users.User_id ORDER by tasks.ID;

Re: [PHP] mmmmm SELECT

2003-01-06 Thread Jason k Larson
Your SQL statement is selecting from two tables, it doesn't know which table the 'active' column belongs to. Try one of the following as appropriate to your schema: tasks.active=yes or users.active=yes HTH, Jason k Larson Bruce Levick wrote: I have this silly problem. This select query

RE: [PHP] mmmmm SELECT

2003-01-06 Thread Bruce Levick
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] m SELECT