RE: Looping through parent and childs

2003-03-04 Thread John Griffin
results. John Griffin -Original Message- From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 6:39 AM To: [EMAIL PROTECTED] Subject: Looping through parent and childs I'm new to mySQL and would like to know how do a SELECT where I get all child re

Looping through parent and childs

2003-03-04 Thread Jakob Vedel Adeltoft
I'm new to mySQL and would like to know how do a SELECT where I get all child records whose root parent=1 Here's my table (project_group_list): group_idparent_group_id 1 0 2 0 3 1 4 3 5