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
