Jump to content

Archived

This topic is now archived and is closed to further replies.

ShopMAster

Need help with Drop down box - noob

Recommended Posts

How do you code a drop down box pulling the info from my mySQL database?

the table is called 'players'.  Thanks.

Share this post


Link to post
Share on other sites
OK. You basically have to get your data from the database and echo it in an HTML select menu. Like this:

[code]<?php
// 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;
?>[/code]

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

Hope that helps,

Niall

Share this post


Link to post
Share on other sites

×

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.