[SOLVED] place loop inside a select form field?

[jarv]

At the moment my code outputs many select boxes with all dates, I want one select box with all the dates, how can i do this?

$result3 = mysql_query("SELECT HeaderDate FROM Headertbl");


while($row2 = mysql_fetch_array($result3))
      {
      $HeaderDate = $row2['HeaderDate'];
echo '<h2><select name="$HeaderDate"><option value="'.$HeaderDate.'">'.$HeaderDate.'</option></select></h2>';
}

[xyn]

I think you mean this:

$result3 = mysql_query("SELECT HeaderDate FROM Headertbl");
print '<h2><select name="$HeaderDate">';
while($row2 = mysql_fetch_array($result3))
      {
echo "<ption value=\"{$row2['HeaderDate']}\">{$row2['HeaderDate']}</option>';
}
print '</select>';

[jarv]

thanks you very much