[ruthlezz1]

I need to know how to populate a list box with the registered users on a site. I am running PHP and mysql database and this form object will be in a module.

Thanks in advance for your help.

[Stefan]

I am not exactly sure what you want. do you want a "who's online" box? if so, it highly depends on the structure of your user database how to create such a box.

[insane]

All you need to do is pull the list out of you database, then build a text string using a WHILE statement, then plug the text string into wherever you want the list box...

here is an example

Code:

while ($player_array = mysql_fetch_array($player_sql)) 
	{
	    $pNa = $player_array["username"];
	    $pId = $player_array["id"];
                 $playerstring .= "<option value=\"$pId\">$pNa</option>";
	}

Now... wherever you want the dropdown box to appear do something like this...

Code:

<select name="player1" size="1">
<option value="">select player</option>
<?=$playerstring?>
</select>