Problem with nested rows

olaf

Hallo,

I created a record set to get some nested rows to use them in a select with option groups.

// the recordset
<?php $categories = mysql_query("SELECT prodGroup, categorie FROM productdetails GROUP  BY categorie ORDER  BY prodGroup, categorie"); ?>

// and the select menu
<select name="categorie" id="categorie">
  <?php while ($row_categs = mysql_fetch_assoc($categories)) {
	  $group = $row_categs['prodGroup'];
	  if ($last_group != $group) {
		  $last_group = $group; 
		  echo "<optgroup label=\"".$row_categs['prodGroup']."\">\n";
	  }
	  echo "<option value=\"".$row_categs['categorie']."\"";
	  echo ($row_categs['categorie'] == $row_updateProduct['categorie']) ? " selected>" : ">";
	  echo $row_categs['categorie']."</option>\n";
  } ?>
</select>

The problem is I can't add the end tag for the optgroup element.

Anyone an idea how to handle this?

Weedpacket

First time through the loop (which you can detect by looking at the value of $last_group - what is that initialised to, incidentally?) write "<optgroup..." as you have now. Every other time the group changes, write "</optgroup><optgroup...>" instead. After the loop, write "</optgroup></select>" and you're done.

olaf

Thanks weedpaket,

After testing, i have a small problem with the test of $last_group. Do you have an example?

olaf

I got it...

		<select name="prodSubGroup">
		  <?php 
		  $last_group = "";
		  while ($row_categs = mysql_fetch_assoc($categories)) {
			  if ($last_group != $row_categs['prodGroup']) {
			  	  echo ($last_group != "") ? "</optgroup>\n" : "";
			  	  echo "<optgroup label=\"".$row_categs['prodGroup']."\">\n";
				  $last_group = $row_categs['prodGroup'];
			  }
			  echo "<option value=\"".$row_categs['categorie']."\"";
			  echo ($row_categs['categorie'] == $_GET['prodSubGroup']) ? " selected>" : ">";
			  echo $row_categs['categorie']."</option>\n";
		  } ?>
		  </optgroup>
		</select>

Thanks for the hint!