[thelist] SQL .. is there a better way ?
rudy
r937 at interlog.com
Sat May 25 23:50:01 CDT 2002
> If anyone wants to hash it out in IRC [1].. a few of us are there
hi michele
i went into the channel, said hi to the half dozen bots, and left
i looked at your sql and it looks okay to me
without seeing your data, i'd guess that you could probably get the counts
from the first result set, and not even bother with the second
assuming you know how to loop through query results more than once
if you must generate the counts in the query along with the details, that
can be done with a UNION but it's ugly, and then you have to skip over the
counts when printing the details
rudy
More information about the thelist
mailing list