Here is the SELECT call.
Code: Select all
$queryplayers = " SELECT * FROM `players` ORDER BY `last_name` ASC";
$resultplayers = mysql_query($queryplayers) or die ("Error in query: $queryplayers. " . mysql_error());
$row3 = mysql_fetch_array($resultplayers);
extract($row3);Code: Select all
<select name="player_id" height=20 multiple>
<option selected>---- Please Select a Player ----</option><?php
while ( $rowplayers= mysql_fetch_array($resultplayers)){extract($rowplayers);
echo "
<option value='$player_id'>$last_name, $first_name</option>"
;}?>
</select>Code: Select all
<input type="hidden" name="player_id" value="00178">
<input type="hidden" name="first_name" value="Rohan">
<input type="hidden" name="last_name" value="Allwood">
<input type="hidden" name="home_town" value="Pinehurst, North Carolina">