[thelist] something wrong with my SQL query

[rudy]

> I don't follow how its 0 or 1!

0 or some other number, 0 being the one you're interested in

> Especially since there can be multiple rows of that id...

well, that's what the COUNT(*) sql function does -- it counts rows

my point is, if all you need is to know how many rows there are, don't bring
them all back into your program (because you aren't using them, right?),
just bring back one number from the database that tells you how many rows
there are

rudy