[Resolved] drop down list

[mattotto77]

Hi,

I have a drop down list which is populated by querying a database, and the selected item will be inserted into a different table.

However if the table already contains something that item will be selected first in the drop down list.

My problem is that if the table has nothing in it the drop down list will automatically select the first item in the drop down list, this could confuse the user, how could i get the default item to be blank then the drop down list therefore informing the user that nothing has been selected so far.

Thanks in advance (my code is below)

<?
print "<form action=\"advisers.php\" method=\"post\">

<select name=\"RegCode\">";

for ($i=0; $i<$number; $i++) {
$RegCode = mysql_result($result2,$i, "RegCode");
$Registrar = mysql_result($result2,$i, "Registrar");

print "<option value=".$RegCode;

if ($RegCode==$origr)
{
print " selected ";
};

print ">".$Registrar."</option>\n";

};

?>

[TTT]

<form action="advisers.php" method="post">
<select name="RegCode">
<?
$option_str = "";
while($rs = mysql_fetch_row($result2)) {
if ($RegCode==$origr) {
$selectedA = 1;
$sel = "SELECTED";
} else {
$sel = "";
}
// RegCode = rs[0]
// Registrar = rs[1]

$option_str =   $option_str."<option value='".$rs[0]."' ". $sel.">".$rs[1]."</option>";

}

if(!isset($selectedA)) {
$option_str = "<option value='0' SELECTED>choose...</option>".$option_str;
}
echo $option_str;
?>
</select>
</form>

[mattotto77]

Hi thanks for the quick reply, i made one slight change

$option_str = $option_str."<option value='".$rs[1]."' ". $sel.">".$rs[0]."</option>";

As i wanted the registrar to be in the drop down but the regcode needs to be inserted into the table.

Although if something has already been inputted in the table its not selecting as default in the drop down.

any ideas???

Thanks

[TTT]

Although if something has already been inputted in the table its not selecting as default in the drop down.

you don't want set current value as selected or what do you mean???? 😕

one bug......
if ($rs[0]==$origr) {

[mattotto77]

Hi

Made this change and it all works perfectly.

if ($rs[1]==$origr) {

Thanks for your time and effort.

[TTT]

😃

remember to mark thread as resolved