[thelist] another mysql order problem
rudy
r937 at interlog.com
Sun Feb 2 19:30:01 CST 2003
> Can anyone suggest what I can do?
1. never do a SELECT inside a loop -- the same results can usually be done
with a join
2. decide whether a given subcategory can belong to more than one parent
if the answer to 2 is yes, then you need two tables, otherwise you only need
one
once you've got that straightened out, could you please give some sample
rows
your column names are rather confusing -- parentid, categoryparentid,
categoryid...
rudy
More information about the thelist
mailing list