I've see a couple of posts on how to do this in ASP and it seems fairly easy. Anyone know how to do it in PHP? What I want to do is build a list of product types (parent) with their respective categories beneath (children) but only the children where the TypeID in parent recordset = ProductTypeID in the child recordset/table.

Parent 1
Child 1.1
Child 1.2
Child 1.3

Parent 2
Child 2.1
Child 2.2
etc...

Any help greatly appreciated... I'll even pay! Thanks.

-Nigel