Retain drop down selected values

[Bravat]

I have several drop down boxes. When submit is clicked it execute query on another page. Problem is when submit is clicked selected values are return to defaults. Is it possible for the values to be remembered after submitting them? Part of the drop down code:

  <?php
            $result = mysql_query("SELECT *
FROM product
GROUP BY Rim");
            ?>
            
  <select id="Rim" name="Rim"  selected="selected" style="width:158px;position:static;z-index:-1;">
  <option value="rim" selected="selected"><?php echo "Rim"; ?></option>

<?php

while ($row = mysql_fetch_array($result)) {
  echo "<option>" . $row['Rim']  . "</option>";
  echo "<br />";
  } ?>
  
       </select> 

 

[Pikachu2000]

Your <option> tags echoed in the while() from the DB query have no value= attribute, so the value won't even be present in the $_POST array if one of them is selected.

[Bravat]

I am not sure that I understand this  At the moment search is working fine. What I need to do?

[iarp]

He said the <option> tags in your while loop do not not have a value="name-here" attribute which is needed.

 

You also don't need selected="selected" on the Rim entry because it's the first entry it default gets selected anyways.

[Pikachu2000]

When an <option> tag has no name= attribute, the value of the <select> in which it resides is empty in the $_POST array with most browsers. Some will take the value of the label and use it as the value in the $_POST array, but that still isn't valid markup.

 

This should make that field's markup valid and retain the value in the field when the form is submitted.

<select id="Rim" name="Rim"  selected="selected" style="width:158px;position:static;z-index:-1;">
  <option value="rim" <?php echo (empty($_POST['Rim']) || $_POST['Rim'] == 'rim') ? 'selected="selected"' : ''; ?>>Rim</option>

<?php

while ($row = mysql_fetch_array($result)) {
  echo "<option value=\"{$row['Rim']}\"";
  echo (!empty($_POST['Rim']) && $_POST['Rim'] == $row['Rim']) ? ' selected="selected"' : '';
  echo ">{$row['Rim']}</option>\n";
}
?>
</select>

[Bravat]

That is what I was looking for. Thank you