Re: listbox problems
| From: | Matt | Date: | Sun, 02 Feb 2003 21:55:08 +0000 |
| Subject: | Re: listbox problems | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134049@lists.php.net to get a copy of this message | ||
>From: "Sunfire" <rusty_81@msn.com>
>Sent: Sunday, February 02, 2003 4:53 PM
>Subject: [PHP] listbox problems
> i have a listbox:
> <select name="users">
> <?php
> //connect to db and get query
> mysql_connect(".....");
> mysql_select_db("...");
> $query=mysql_query("select username from users);
> /*finish the listbox*/
> while($account=mysql_fetch_array($query)){
> echo "<option value=$account[username]>$account[username]<br>";
Try:
echo "<option value={$account['username']}";
$selected = ($account['username'] == $_POST['user']) ? 'selected' :
'';
echo $selected;
echo ">{$account['username']}<br>";
> }
> ?>
> </select>
> <input type="submit" value="send">