Re: mmmmm SELECT

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"; #################################################### But when I add a further filter (AND active="yes") ....it comes up blank...currently all the active rows in the tasks table are equal to "yes" so they should still display, but comes up with a blank. #################################################### $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??

If this is the query you are actually using, it is causing a PHP syntax error due to the nested double-quotes. Use $query_retrievetasks = "SELECT * FROM tasks, users WHERE tasks.UID = users.User_id AND active='yes' ORDER by tasks.ID"; Note the single-quotes around 'yes'. I'm guessing your installation is set up to not echo PHP errormessages back to the screen, that's why you didn't see an error message.

        -steve

+------------------------------------------------------------------------+

| Steve Edberg                                      sbedberg@ucdavis.edu |
| Database/Programming/SysAdmin                            (530)754-9127 |
| University of California, Davis             http://pgfsun.ucdavis.edu/ |

+---------------------- Gort, Klaatu barada nikto! ----------------------+