[thelist] MySQL query help

[NanHarbisonSmith at aol.com]

--
[ Picked text/plain from multipart/alternative ]
I noticed that all of the fields in the db dump were lowercase, and some of
them are being referenced as title case. My version of MySQL does not grab
data when the name of the field is in the wrong case, such as if I return
$Row[Name] and the real column name in the db is Row[name], I will get no
rows returned.
Nan

> 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.