Dynamic Menu

[plasmahba]

Hi

I`m wondering if there's a way to call a result from a database to shows selected in a drop menu

I have done this dynamic menu calling the options from my database and it works ok

<?
$options="";

while ($row=mysql_fetch_array($Result)) {
$ID=$row["ID"];
$options.="<OPTION VALUE=\"$ID\">".$ID;

}
?>

<select name="name" size="1" id="name">
<option selected>Select Please</option>
<option>
<?=$options?>
</option>
</select>

Now if somebody can give a direction of how can I get a result selected I will apreciate it a lot

Thanx

[olaf]

try this:

<?php
$options = "";
while ($row = mysql_fetch_array($Result)) {
	$options .= "<OPTION VALUE=\"".$row["ID"]."\"";
	$options .= ($name == $row["ID"]) ? " selected>" : ">";
	$options .= $row["ID"]."\n";
}
?>

<select name="name" size="1" id="name">
  <option selected>Select Please</option>
  <?php echo $options; ?>
</select> 

[concept0020]

This is how I did mine...

  $your_select="<select name=\"which\">\n";
  $your_select.="<option value=\"\"> [-- -Select a user- --] </option>";
  while($row=mysql_fetch_assoc($result)) {
    $your_select.="<option value=\"{$row['user_name']}\">{$row['user_name']}</option>";
  }
  $your_select.="</select>";

Then when building the page I display the drop down

 $your_select <input type="submit" name="submit" value="Select" />

To get the value that was selected

  if ($_POST['submit'] == 'Select') {
    $selected_name = $_POST['which']; //where which is what you named the dropdownbox The value that was selected is now #selected_name }

Hope that helped some