[MySQL] hierachy problem ...

Ok I think I have the solution:

select t1.label as Parent, t2.label as Child from table t1
left join table t2
on t1.id=t2.idParent
order by t1.label, t2.label

This results in:

+----------------+
| Parent | Child |
+----------------+
| A | AA |
| A | AB |
| A | AC |
| AA | AAA |
| AA | AAB |
| AB | ABA |
| AAB | AABA |
| B | |
| C | CA |
| C | CB |
+----------------+

and so on ...

Now I have to find a php script that displays the correct tree ...
 >> Stay informed about: [MySQL] hierachy problem ... 

Here is my request for now:

select p.label as Parent, c.label as Child from table p
join table c on c.idParent=p.id
order by p.label


But the children with no parent are not displayed ...
what's wrong?



pounch wrote:
 > Hello,
 >
 > I have a table which have these fields:
 > - id
 > - idParent
 > - label
 >
 > I would like to display each field and his children but each parent may
 > have no child.
 >
 > Example:
 > A
 > AA
 > AB
 > AC
 > B
 > C
 > CA
 > CB
 > ...
 >
 > I can't write the request, could you help me? :-p
 > Thanks
 >
 > Dams
 >> Stay informed about: [MySQL] hierachy problem ...