$populateplayers = ("SELECT * FROM player ORDER BY playername ASC");
        $players = mysql_query($populateplayers);

            if (!$players)
                {
                    die ('Can\'t do it : ' . mysql_error());
                }
            echo '<select class="dropdown" name="player1">\n';
            while($playersrow = mysql_fetch_assoc($players))
            {
                $playerCvalue = $playersrow['playerCvalue'];
                $playername = $playersrow['playername'];
                $userid = $playersrow['id'];
                echo "<option value='$playerCvalue'>$playername</option>\n";
            }
            echo "</select>\n";

    ?>


-----------------------------------------------

// JavaScript Document

var playerchoice = document.getElementById('playerchoice');

window.addEvent('domready', function() {
    var playerchoice = document.getElementById('playerchoice');

    playerchoice.onchange = function() {
        var index = playerchoice.selectedIndex;
        var elo = playerchoice.options[index].value;
        alert(elo);
    }
});