Jump to content

Need help with Drop down box - noob


Recommended Posts

OK. You basically have to get your data from the database and echo it in an HTML select menu. Like this:

// connect to your database here
$conn = mysql_connect("localhost", "dbuser", "dbpass");
mysql_select_db("dbname", $conn);

// Make the query
$sql = mysql_query("SELECT * FROM players");

// Start the html select menu
$html = '"<select name="player_menu" id="player_menu">";

// Echo the results in a loop and add each option
while($row = mysql_fetch_assoc($sql)) {
    $html .= '<option value="'.$row['player_id'].'">'.$row['player_name'].'</option>\n';

// End the html select menu
$html .= '</select>';

// Echo the select menu
echo $html;

You may need to change some table/field names but it should work. :)

Hope that helps,

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.