How to place the 'selected' attribute in an option tag ?

[webnology]

Hi all,

small problem. I use the below code to generate a drop down list, built from a database table:

<?php 
//Display list of all types
$query_vestigingen="SELECT vestiging_id, vestiging FROM vestigingen WHERE dealer_id = '$dealer_id'";
                
$result_vestigingen = mysql_query($query_vestigingen);
echo "<select name=vestiging_id value=''>vestiging</option>";
                
while($nt=mysql_fetch_array($result_vestigingen)){
echo "<option value=$nt[vestiging_id]>$nt[vestiging]</option>";
}
echo "</select>"; 
?>

This works fine. My question is, how can I detect the value which is actually mentioned in the database and have the drop down automatically display the right value ? I have a page where I need to update the values for a specific car, so for the update page, I need the dropdown list to show the saved data which is in the db.

I tried like this, but I can't make it work, I'm stuck I guess with the ' and the "

echo "<option value=$nt[vestiging_id] if ($nt[vestiging_id] == $vestiging_id_db) echo 'selected'>$nt[vestiging]</option>"; 

where $vestiging_id_db is the value which is mentioned in the db. So I would like the drop down box to display the value $vestiging_id_db.

Any ideas why it doesn't work?

Kind regards,
Michel

[Raju Gautam]

This will work for you:

    //Display list of all types
    $query_vestigingen="SELECT vestiging_id, vestiging FROM vestigingen WHERE dealer_id = '$dealer_id'";
    $result_vestigingen = mysql_query($query_vestigingen);
    //lets suppose your selecting id is 2;
    $selid = 2;
    echo "<select name=vestiging_id value=''>vestiging</option>";
    while($nt=mysql_fetch_array($result_vestigingen)){
        if($selid == $nt[vestiging_id]){
            echo "<option value=\"$nt[vestiging_id]\" selected>$nt[vestiging]</option>\n";
        }
        else{
            echo "<option value=\"$nt[vestiging_id]\">$nt[vestiging]</option>\n";
        }
    }
    echo "</select>"; 

[cranial-bore]

Just use single quotes so you don't need to escape double quotes. Unnecessary escaping causes cancer.

You may not be seeing the preselected value if you are hitting refresh in Firefox. It remembers your last "entry" between page requests. You need to hit enter from the address bar to request the page again for the selected to take effect.