drop down menus

[weazy]

i have a system that creates a drop down menu from a database to allow users to select an option, when the user submits the form, the form first shows a confirmation page that also allows the user to make changes on the confirmation page. the problem is that the option the user selects from the drop down menu does not show on the confirmation page, it just shows the first item in the list.....

[weazy]

My code on the first form page looks like:

function prefix_type()
{
// displays a menu with prefix
db_connect();
$sql = mysql_query("SELECT prefix_id, prefix_name FROM prefix") or die (mysql_error());
echo "<select name=\"prefix_id\">";
while(list($prefix_id, $prefix_name) = mysql_fetch_array($sql))
{
$prefix_name = stripslashes($prefix_name);
$prefix_name = ucfirst($prefix_name);
echo "<option value=\"$prefix_id\">$prefix_name</option>";
}
echo "</select>";
mysql_free_result($sql);
}

my code on the confirmation page looks like:

db_connect();
$sql = mysql_query("SELECT prefix_id, prefix_name FROM prefix") or die (mysql_error());
echo "<select name=\"prefix_id\">";
while(list($prefix_id, $prefix_name) = mysql_fetch_array($sql))
{
$prefix_name = stripslashes($prefix_name);
$prefix_name = ucfirst($prefix_name);
echo "<option value=\"$prefix_id\"";
if ($prefix_id == $prefix_id){
echo " SELECTED";
}
echo ">$prefix_name</option>";
}
echo "</select>";
mysql_free_result($sql);

the result i get is:
<select name="prefix_id"><option value="1" SELECTED>Dr</option><option value="2" SELECTED>Miss</option><option value="3" SELECTED>Mr</option><option value="4" SELECTED>Ms</option><option value="5" SELECTED>Mrs</option></select></td>

[thorpe]

no where in this code are you displaying the data the user posted from first page.

the code in your confirmation is almost identicle to the originating page....what do you expect.

you confirmation page should look more like.

<?php

  echo 'you have selected<br />';

  echo $_POST['blah'];
  echo $_POST['boo'];
  echo $_POST['hey'];

?>

of course if you want to allow changes, you would need to work this into a form, and you may need to run your dropdowns query again. but this should give you an idea.