Assuming that you know which state is selected before you build the
select list:

$sel_state = $_REQUEST['state'];

...

while($row = mysql_fetch_array($result)) {
    $buyerid = $row['buyerid'];
    $state = $row['state'];
    $selected = $state == $sel_state ? "selected=\"selected\"" : "";

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

That will put the string "selected=\"selected\"" (xhtml compliant) into
the option statement for the state that was selected.

..michael..

On Wed, 2003-01-22 at 10:14, Ben C. wrote:
> 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>
>  
> --------------------------------
-- 
Michael Sweeney <[EMAIL PROTECTED]>
Verisity Design, Inc


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

Reply via email to