If I have a statically populated drop list (using values stored in database), how can I use sticky values?
I want the chosen value to remain after a failed validation. I know how to do this when I manually populate the drop list:
[code=php]<select name=”name” class=”style1″>
<option value=””>(choose)
<option value=”Name1″ <?php if (isset($_SESSION[‘name’]) && $_SESSION[‘name’] == ‘Name1’) { echo ‘ selected=”selected” ‘; } ?> >Name1
</select>
However, how would I do this when querying the db for the list like the following?
[code=php]$queryNameDrop = mysql_query(”
SELECT name
FROM user”) or die(‘Query failed: ‘ . mysql_error());
echo “<p class=’style1′>User:</p>”;
echo “<select name=’dropName’ class=’style1′>”;
echo “<option value=”>”;
while($row = mysql_fetch_array( $queryNameDrop ))
{
$list = $row[‘name’];
echo ” nt<option value=”{$list}”>{$list} “;
}
echo “</select>”;