Default value for formfield

[Jack2003]

Hi,

I have a php-page with a formfield that contains values from a mysql database.

      <option value="<?php echo $row_Rubriek['Rubriek']?>"><?php echo $row_Rubriek['Rubriek']?></option>
      <?php

} while ($row_Rubriek = mysql_fetch_assoc($Rubriek));
$rows = mysql_num_rows($Rubriek);
if($rows > 0) {
mysql_data_seek($Rubriek, 0);
$row_Rubriek = mysql_fetch_assoc($Rubriek);
}
?>

After a submit of the form the formfield rebuilds to all the databasefield values. Is it possible to point to the last used value of the formfield?

Thanks in advance,
Jack

[hthighway]

I usually do something like below:

put the data that I want displayed in the drop down into an array then loop through the array to build the drop down

echo "<select name=\"form_01\">";
foreach($db_array as $key => $value)
{
  $selected = "";
  if($form_01 == $value)
  {
     $selected = "selected";
  }
  echo "<option value='".$value."' ".$selected.">".$value."</option>";
}
echo "</select>";

[zcketcher]

What about hidden fields in your form. Set the value of them to whatever you want to be persistent.