[PHP] Select value for driopdown box

[Ben C .]

I am using the query below to edit a record. I want to edit the field which has a list 
of states in a dropdown box.   I want to have the state that is in the selected field 
shown as the selected state.  How would I do this?


Query
-------------------------
<?
$sql = "SELECT *
        FROM $table_name
        WHERE buyerid = \"$buyerid\"
        ";

$result = @mysql_query($sql,$connection) or die(mysql_error());

        
while ($row = mysql_fetch_array($result)) {
         $buyerid = $row['buyerid'];
         $state = $row['state'];

        $option_block .= "<option value=\"$state\">$state</option>";
}

$display_block = "

<select name=\"state\" class=Pgtext>
$option_block
</select>
?>

<tr>
<td width="258" class="Pgtext" height="21">State</td>
<td width="259" height="21"><? echo $display_block; ?></td>
</tr>
 
--------------------------------


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php