Grouping on more than one level

kene

I need to be able to output a list of members that is grouped on more than one level. I can handle one level easy enough, but have sub groups under the first level is presenting problems. I've tried various things, but seem to be getting no where.

The output should look something like this:
Fishing
Fly-in-Fishing
City - Member name
City - Member name
Charter Fishing
City - Member name
City - Member name

Golf
City - Member name
City - Member name

Fishing has two sub categories and Golf has none. The code I currently have will produce the main categories of Fishing and Golf, but none of the sub categories under fishing. Everybody ends up in the main category. The sub category name is never listed.

Here is the current code that doesn't work. I think I need a new pair of eyes or two to point out where I'm going wrong.

<?php
$category = "";
$subCategory = "";
echo("<dl><font size=\"2\">");
while($row = mysql_fetch_array($result)){
	if($row[ActivityName] != $category){
		$category = $row[ActivityName];
		$categoryUpper = strtoupper($category);
	echo("<dt><br /><a name=\"$category\" class=\"heading\"><b><img src=\"images/bullet.gif\" width=\"12\" height=\"12\" align=\"middle\" alt=\"\">&nbsp;$categoryUpper</b></a>");	
		if($row[RegionSubName] != $subCategory && $row[RegionSubName] != ""){
		$subCategory = $row[RegionSubName];
		echo("<br><span style=\"padding-left:25px; font-size:12px;\"><b>$subCategory</b></span>");
		}
	}	
	echo("<br /><dd>$row[City] - <a href=\"Member/$row[SiteName]/index.htm\">$row[MemberName]</a></dd>");
}
	echo("</font></dl>");
?>

Thanks for any help.

Roger_Ramjet

OK. I'm not going to try and do it with your code - too much html getting in the way.

Here is the model and it's logic


// assuming a well ordered query result set with all  fields in every row

// set up markers for branch
$c = "";
$s = "";

while ($row = mysql_fetch_array($result)) {
   if ($row['cat'] != $c) {
      echo $row['cat'] . '<br />';          // new category so display it
      $c = $row['cat'];                     // record current category
      $s = "";                              // new category so any subcategory must be new
      if ($row['subcat'] != "") {           // if there is a subcategory
      	echo $row['subcat'] . '<br />';     // display it
      	$s = $row['subcat'] . '<br />';     // record current subcategory
      }
      echo $row['item'] . '<br />';         // display the item
    }
    else {                                  // not a new category
       if (($row['subcat'] != "") && ($row['subcat'] != $s)) {  // if there is a subcategory and it is new
          echo $row['subcat'] . '<br />';   // display new subcategory
          $s = $row['subcat'];              // record current subcategory
        }
        echo $row['item'] . '<br />';       // display item whether there was a subcat or not
    }
}

kene

Thanks for the guidance. That worked after I made a few changes to the code. Here is the final code with most of the html stuff removed.

$c = ""; 
$s = "";
while ($row = mysql_fetch_array($result)) { 
   if ($row['ActivityName'] != $c) { 
   		$c=$row['ActivityName'];
	echo $c;
      $c = $row[ActivityName];                     // record current category 
      $s = "";                              // new category so any subcategory must be new 
      if ($row[SubName] != "") {           // if there is a subcategory           

		  echo$row[SubName];     // display it 
          $s = $row[SubName];     // record current subcategory 
	  echo<dd>$row[City] - $row[MemberName]</dd>;
		}
	else{
	echo <br /><dd>$row[City] - $row[MemberName]</dd>;
		}
	}

else {                               // not a new category 
   if (($row[SubName] != "") && ($row[SubName] != $s)) {  // if there is a subcategory and it is new 
      echo $row[SubName];   // display new subcategory 
      $s = $row[SubName];              // record current subcategory 
     echo<dd>$row[City] - $row[MemberName]</dd>; 
	} 
	else{
	echo<br /><dd>$row[City] - $row[MemberName]</dd>;
	}
}		
}

Roger_Ramjet

Good. Glad it woks.

Just one point, you are repeating yourself at one place. Not important as it stands, but it's a setup for a bug if you ever change this and miss the repeated operation


if ($row['ActivityName'] != $c) { 
           $c=$row['ActivityName'];  // record current category 
    echo $c;
      $c = $row[ActivityName];      // record current category TWICE ?? and the syntax is wrong !! Just loose this line.

kene

Sorry. I was just copying in the code and stripping html things out and somehow ended up with that repeated line in what I copied. It wasn't in the final code, just what I posted back as an example. Should have been a little more careful

Thanks again.