function DrawOptions($options, $active='')
{
$str = '';
foreach($options AS $key=>$value)
{
$sel = ($active==$key?" SELECTED":"");
$str .= "<option value='".$key."'".$sel.">".$value."</option>\n";
}
return($str);
}
Try this
<select name='something'>
<?=DrawOptions($array, $active)?>
</select>
array needs to be a key-value pair that has the value that you are looking
for as the key and if it matches it will make that key - value assoc the
selected one.
that should work for you
----- Original Message -----
From: "Ben C." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 10:14 AM
Subject: [PHP] Select value for driopdown box
> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
