Jump to content

Need help with Drop down box - noob


ShopMAster

Recommended Posts

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

Archived

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

×
×
  • 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.