choosing selected option based on a variable

[lorddraco98]

quick question.

I'm going to have a selection drop down list that pulls it's data from the DB.
So say I have the following date:

Title

1. A
2. B
3. C
4. D

the title is my column name and then each of the number are DB entries. So I'll have a query and create a selection list that contains the options" A, B, C, and D:.

Now Say I have a variable called $test.
now say:
$test= C;

how do I have it so that in the drop down box, whatever option corrasponds to the variable $test is selected?

[kevinsequeira]

<?php
$test = "C";

// db connections and query
// looping resultset
?>
<select name="blah">
<?php
while($row=mysql_query($result)){
if($row['title']=="$test"){
$selected="selected";
}else{
$selected = "";
}
echo '<option value='.$row['title'].' '.$selected.'>'.$row['title'].'</option>';

}
?>
</select>

reg
kevin

[Jinks]

i usually just put it right in the option but i guess thats messy..

<option value="1" <? if ($test == c) echo "selected"; ?>>Option C</option>