[Resolved] List names in a 'select' menu

[Dr_Flink]

I want to show all names (24 of them) that exists in the tabel 'players'. These names I want to appear in a drop down menu. But the thing is that only the first name from the tabel appears 24 times! How do I do to make the names change?

<?
$query = mysql_query("select * from players") or die(mysql_error());
$row = mysql_fetch_array($query);

$i = 0;
while ($i < $numQuery) {
	$i++;
	print '<option>' . $row['name'] . '</option>';
}
?>

[TheDefender]

In addition to the main change in the loop, there are some other changes I made for better syntax... Make note of them and apply them accordingly when you code.

<?php //Note the addition of the php after the <?.  Always use long tag syntax.

$query = mysql_query("select * from players") or die(mysql_error()); 

while($row = mysql_fetch_array($query)) { 
        print '<option />' . $row['name']; // Note the removal of the </option> tag and the addition of the / in the <option /> tag.  It better follows the HTML/XML guidelines established by the W3C.
} 
?> 

[Dr_Flink]

I tested the code u gave me and got following errors:

Warning: mysql_connect(): Too many connections in /export/vol1/unix/r/raiswm/public_html/variabler.php on line 1

Warning: mysql_select_db(): Too many connections in /export/vol1/unix/r/raiswm/public_html/variabler.php on line 1

Warning: mysql_select_db(): A link to the server could not be established in /export/vol1/unix/r/raiswm/public_html/variabler.php on line 1

[TheDefender]

That error has nothing to do with the code I gave you, just to let you know...

[Dr_Flink]

oooops, so I noticed ...now :queasy:

Still have a litle bit of a hangover 😉

[Dr_Flink]

Yes, now it's working perfect!
Thanks for your help!!!

[TheDefender]

You're welcome. Have yourself a good night/day. (depending on your locale)