Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display a query in a dropdown.
- Thread starter eter4
- Start date
assuming you want the drop down box on a web page and using php, then
1. run your select query
$result = mysql_query("select state_id, state_name from table", $dbconnection);
2.populate your combo
$html_output = '<select name="states">';
while($state = mysql_fetch_array($result)) {
$html_output .= '<option value="'.$state["state_id"].'">'.$state["state_name"].'</option>';
}
$html_output .= '</select>';
echo $html_output;
hope this helps
1. run your select query
$result = mysql_query("select state_id, state_name from table", $dbconnection);
2.populate your combo
$html_output = '<select name="states">';
while($state = mysql_fetch_array($result)) {
$html_output .= '<option value="'.$state["state_id"].'">'.$state["state_name"].'</option>';
}
$html_output .= '</select>';
echo $html_output;
hope this helps
- Status
Similar threads
- Locked
- Question
