Hi,
I originally asked at codewalkers about creating infinite layers of categories.
Thus, I would have a table such that:
int id
int parentId
And I want to fetch all parents of a layer like this:
select * from layers a left join layers b where b.id=a.parentId left join layers c where c.id=b.parentId ?
However, would it be better to just call mysql_query each time per parent layer I'm fetching? Or, is it better to get all data in one call like I've done above?
My main concern is that I want to make this as friendly on a shared-hosting server as possible.
Thanks.
