[thelist] MySQL query with two left joins

Kristof Neirynck k.neirynck at belgacom.net
Mon Jun 30 12:25:09 CDT 2003


> What I am trying to do is, for example, print a list of the 
> sub-categories of Category 2, which would include Category 2 a, Category 
> 2 b, and Category 2 c. I don't want to include the children of the 
> children. This list should then include a count of the sub-categories 
> and documents contained in Category 2 a, Category 2 b, and Category 2 c, 
> respectively.

Did you read this yet?
<http://www.sitepoint.com/article/1105>


Kristof



More information about the thelist mailing list