scrolldown menu

[emfung]

I want to put a scrolldown menu in a form, I know how to script simple html code for scrolldown menu but have no idea how to do it with php. Obviously I want the selected option in the scrolldowm menu (when user select it) will be stored in the msql database.

Can anybody construct me the code?

Somebody already taught me how to do this with radio buttons, like this:

<?php
switch($CheckBoxName)
{
case'0';
$Check1 = 'checked';
$Check2 = '';
break;
case'1';
$Check2 = 'checked';
$Check1 = '';
break;
}
print'
<input name="CheckBoxName" type="radio" value="0" $Check1 /><br />
<input name="CheckBoxName" type="radio" value="1" $Check2 />';

?>

Thank you

[mystrymaster]

scroll down menu?

Does that mean a drop down box or a multiple selection option?

Either way it would be very similiar.

What you came up with there is for a check box and if thos are the choices you want in the drop down it would be something like this. if it only has two choices.

$sql = "SELECT fieldname FROM databasename";
$results = mysql_query($sql);
$row = mysql_fetch_array($results);
echo "<SELECT name='choose'>";
echo "<option value='0' ";
if ($results[fieldname] == 0) {
echo "selected";
}
echo "Yes</option>";
echo "<option value='1' ";
if ($results[fieldname] == 1) {
echo "selected";
}
echo "Yes</option>";
echo "</select";