Looped results in drop down list

micmac

Hi all,
Lets assume i have the following mySQL table structure:

catID  catParent  catName

1      0          Home
2      1          Guys
3      1          Girls
4      1          Kids
5      1          Accessories
6      1          Limited Ed.
7      1          Specials
8      2          T-Shirts/Singlets
9      2          Jackets/Jumpers
10     2          Pants/Shorts
11     3          Jackets/Jumpers
12     3          T-Shirts/Singlets
13     3          Skirts/Pants
14     4          Boys
15     4          Girls
16     14         Jackets/Jumpers
17     14         T-Shirts/Singlets
18     14         Pants/Shorts
19     15         Jackets/Jumpers
20     15         T-Shirts/Singlets
21     15         Skirts/Pants

What i was wanting to do was to output the results into a drop down list. I only want to display the end category and its parents, for example:

Guys >> Shirts/Singlets
Guys >> Jackets/Jumpers
Guys >> Pants/Shorts
Girls >> Shirts/Singlets
Girls >> Jackets/Jumpers
Girls >> Skirts/Pants
Kids >> Boys >> Jackets/Jumpers
Kids >> Boys >> T-Shirts/Singlets
Kids >> Boys >> Pants/Shorts
Kids >> Girls >> Jackets/Jumpers
Kids >> Girls >> T-Shirts/Singlets
Kids >> Girls >> Skirts/Pants
Accessories
Limited Ed.
Specials

Does anyone know how to do this? I've tried doing queries within queries but never seem to get the requires result. I aslo don't want the first row from the database to display, eg. Home.
Cheers,
micmac

sidney

this is close needs a bit of work

 <?php 
require("connect.php");
$query1="SELECT * FROM tablename WHERE catparent=1 ORDER BY catid";
$sql1=mysql_query($query1);
while($row1=mysql_fetch_assoc($sql1))
	{echo $row1['catname']."<br>";
	$query2="SELECT * FROM tablename WHERE catparent='".$row1['catid']."' ORDER BY catid";
	$sql2=mysql_query($query2);
	while($row2=mysql_fetch_assoc($sql2))
		{
		echo $row1['catname'].">>".$row2['catname']."<br>";
		$query3="SELECT * FROM tablename WHERE catparent='".$row2['catid']."' ORDER BY catid";
		$sql3=mysql_query($query3);
		while($row3=mysql_fetch_assoc($sql3))
			{
			echo $row1['catname'].">>".$row2['catname'].">>".$row3['catname']."<br>";
			}
		}
	}		
?>

output

Guys
Guys>>T-Shirts/Singlets
Guys>>Jackets/Jumpers
Guys>>Pants/Shorts
Girls
Girls>>Jackets/Jumpers
Girls>>T-Shirts/Singlets
Girls>>Skirts/Pants
Kids
Kids>>Boys
Kids>>Boys>>Jackets/Jumpers
Kids>>Boys>>T-Shirts/Singlets
Kids>>Boys>>Pants/Shorts
Kids>>Girls
Kids>>Girls>>Jackets/Jumpers
Kids>>Girls>>T-Shirts/Singlets
Kids>>Girls>>Skirts/Pants
Accessories
Limited Ed.
Specials

micmac

Thanks Sid, you got it in one!

Cheers,
micmac

sid

if you want it to be more flexible, you could also use a recursive function.