Dynamic Dropdown menu

[jeffrife]

I have been working at this project for a few weeks and am at a loss. I have a table named "players" with 5 rows (ID, Fname. Lname, Wins, Games). I am trying to create a dynamic drop down that pulls at least populates with the Fname column. This is what I have so far:

The HTML part:

<select id="e9" class="cc26" size="1" name="combo_box" onchange="alert('Combo_Box'+'['+this.selectedIndex+']')">
<?php do {
?>
<a href="submitplayers.php?playerID=<?php echo $rsPlayers ['playerID']"><?php echo $rsPlayers ['Fname']; ?></a>

<?php
} while ($rsPlayers = mysql)fetch_assoc($players_query));
?>
</select>

The PHP page:

<?php

mysql_connect("localhost","database","newpassword");
mysql_select_db("database");

$players_sql = "SELECT * FROM players";
$players_query = mysql_query($players_sql) or die(mysql_error());
$rsPlayers = mysql_fetch_assoc($players_query);

?>

Thank you for any guidance!

[jorgepinho]

Hi,

Using a <a> tag inside a <select> will not work as you want.

you should use <option>

<option value="<?php echo $rsPlayers ['playerID']">"><?php echo $rsPlayers ['Fname']; ?></option>

Then you should surround the code with a <form> tag

<form action="submitplayers.php" method="POST">

All the code you posted are on the same page, right ? PHP first, then HTML ?