[Resolved] drop down list

[ritu]

i have made a function to print a list of username from the mysql database as a dropdown list. But I am not able to provide a default selection for a username.
How can I do that?

[Frapster]

can you post the code you're trying to use? I just spent the last 4 days working on this for my site and I actually might be able to help you.

[devinemke]

an example (#3 is the default):

<form>
<select name="users">
<option>user #1
<option>user #2
<option selected>user #3
<option>user #4
<option>user #5
</form>

[ritu]

well, i sort of figured it out myself...
suppose the database contains list of usernames and I wanna keep "ritu" as default, then

$query="select user from userlist";
$result=mysql_query($query);

while($row=mysql_fetch_array($result))
{
echo "<option value=\"$row['user'] \"
if($row['user']=="ritu") echo "selected"; >$row['user']";
}

[ritu]

Originally posted by Frapster
can you post the code you're trying to use? I just spent the last 4 days working on this for my site and I actually might be able to help you.

hello frapster,
well, i sort of figured it out myself...
suppose the database contains list of usernames and I wanna keep ritu as default, then

$query="select user from userlist";
$result=mysql_query($query);

while($row=mysql_fetch_array($result))
{
echo "<option value=\"$row['user'] \"
if($row['user']=="ritu") echo "selected">$row['user']";
}