here is my question .... this might be a bit confusing so please be patient
what am doing is using while loop to display data from the database, in this case they are categories. the code for this is below...
$query = "SELECT DISTINCT cat FROM product";
$result = mysql_query( $query, $link );
printf ("<span class='body'><b> $cat </b><br><br></span>");
this works fine ... it lists the categories in this fasion;
Category3 and so on ...
what i want to do is to list also subcategories in in this fasion;
Do i have to use another while loop to list the subcategories ?
if so where and how do i put there ?
Please help ...
thanx in advance .