ShopMAster Posted July 9, 2006 Share Posted July 9, 2006 How do you code a drop down box pulling the info from my mySQL database?the table is called 'players'. Thanks. Link to comment https://forums.phpfreaks.com/topic/14118-need-help-with-drop-down-box-noob/ Share on other sites More sharing options...
Gast Posted July 9, 2006 Share Posted July 9, 2006 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 optionwhile($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 menuecho $html;?>[/code]You may need to change some table/field names but it should work. :)Hope that helps,Niall Link to comment https://forums.phpfreaks.com/topic/14118-need-help-with-drop-down-box-noob/#findComment-55291 Share on other sites More sharing options...
ShopMAster Posted July 10, 2006 Author Share Posted July 10, 2006 Thanks Gast! Link to comment https://forums.phpfreaks.com/topic/14118-need-help-with-drop-down-box-noob/#findComment-55566 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.