List/Menu

[andrew_ww]

Hello,

I have a list/menu object which is populated dynamically from a database.

Here is the code which is driving this:

[code]<form action="" method="get"><select>
  <?php
do { 
?>
  <option value="<?php echo $row_rs_list['delivery_id']?>"><?php echo $row_rs_list['review_type']?></option>
  <?php
} while ($row_rs_list = mysql_fetch_assoc($rs_list));
  $rows = mysql_num_rows($rs_list);
  if($rows > 0) {
      mysql_data_seek($rs_list, 0);
      $row_rs_list = mysql_fetch_assoc($rs_list);
  }
?>
</select></form>[/code]

---------------------------------------------------------------------------------------------------------------------------

I have other fields within the recorset.  What I would like to do is if the first item (delivery_id = 0) is selected then all other values in this row are displayed, consquently if I were to select the 2nd choice then all the values would be displayed on the page.

For this example say the other values that I won't to display are called values01, values03 and value04

Any ideas how I could achieve this ?