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!
PHP MySQL populate drop down list
- Thread starter kpdvx
- Start date
<?php
$result = mysql_query("SELECT drop_down FROM database",$db);
echo "<select name=drop_down>\n";
while ($row = mysql_fetch_array($result)) {
echo "<option value=$row[0]>$row[0]</option>\n";
}
echo "</select>\n";
?> ***************************************
Party on, dudes!
![[cannon]](/data/assets/smilies/cannon.gif "[cannon] [cannon]")
$result = mysql_query("SELECT drop_down FROM database",$db);
echo "<select name=drop_down>\n";
while ($row = mysql_fetch_array($result)) {
echo "<option value=$row[0]>$row[0]</option>\n";
}
echo "</select>\n";
?> ***************************************
Party on, dudes!
- Thread starter
- #3
OK all notes are //<notes> the // will preven php from parsing this text.
----------------dropdown.php----------------------
<?php // begin php code
// connect to mySQL
$db = mysql_connect("localhost", "username", "password"
or die ('Cannot connect to database');
// select the database
mysql_select_db("your_database",$db) or die ('database not available');
// select the column from your database which contains the items to populate the drop down list
$sql='SELECT drop_down FROM database';
// run the query on the selected database using the connection details above
$result = mysql_query($sql,$db);
// start the drop-down html
echo "<select name=drop_down>\n";
// split the query results into rows to populate the select box
while ($row = mysql_fetch_array($result)) {
// add each item in the result to the select box
echo "<option value=$row[0]>$row[0]</option>\n";
// end the while statement
}
// end the select box
echo "</select>\n";
// close the php tag
?> ***************************************
Party on, dudes!
----------------dropdown.php----------------------
<?php // begin php code
// connect to mySQL
$db = mysql_connect("localhost", "username", "password"
or die ('Cannot connect to database');// select the database
mysql_select_db("your_database",$db) or die ('database not available');
// select the column from your database which contains the items to populate the drop down list
$sql='SELECT drop_down FROM database';
// run the query on the selected database using the connection details above
$result = mysql_query($sql,$db);
// start the drop-down html
echo "<select name=drop_down>\n";
// split the query results into rows to populate the select box
while ($row = mysql_fetch_array($result)) {
// add each item in the result to the select box
echo "<option value=$row[0]>$row[0]</option>\n";
// end the while statement
}
// end the select box
echo "</select>\n";
// close the php tag
?> ***************************************
Party on, dudes!
- Status