[thelist] MySQL query help

I have a sneaking suspicion this isn't the code, but instead the logic of
the programmer/database that is the problem

Think about your database schema.  Why is it only returning on?  Are there
entries in all of the tables for each entry?  With the queries we've all
sent you, it is assuming that there are aligning values in all of the tables
so that a row query wont return blank values.  Check your database.

David
www.confluentforms.com