[thelist] another mysql order problem

> 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