Display and Post from Database.

[marcinmf]

Hello I need help, I am building page, where user has to choose form couple drop down menus, options will be positions from MySQL table. After choosing options from drop down menus, there should be submit button that will open new page where are printed previously selected options. This page also will have to be saved on server.
I have databases created already, I don’t know ho to display data in drop down menu, as well posting or saving. Please help.

[lucasrd]

echo "<select name='positions'>";

$sql = "your query";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){

  echo "<option value='".$row['position_id']."'>".$row['position_name']."</option>\n";

}

echo "</select>";

Then on the page you POST your form to, you should be able to access the position they selected by using this variable:

$_POST['position']