[php] Select-Problem

[Ralf Eggert]

Moinsen Guenther,

versuchs mal hiermit:

  SELECT a.id, count(b.id) as anzahl
  FROM tabelle AS a 
  LEFT JOIN tabelle as b 
  ON a.id = b.parent
  WHERE a.parent = 0 
  GROUP BY a.id

Klappts?

Gruss,

        Ralf

-- 
__________________________________________
 In-Greece.de - die Griechenlandcommunity
_______ http://www.in-greece.de/ _________