Dropdown lists from a mysql db - DevShed Discussion Forums

★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum5/HTML/000697.html

Nouvelle recherche | Portail wanayoo

DevShed Menu

* DevShed Home

* Developer News

* DevShed Brain Dump

UBBFriend: Email This Page to Someone!

DevShed Discussion Forums

PHP

Dropdown lists from a mysql db

profile | register | preferences | faq | search

next newest topic | next oldest topic

Author

Topic: Dropdown lists from a mysql db

bbrown
Member

posted March 07, 2000 04:09 PM

Id like to load a drop down list from a mysql database using php3 and create a link to that record. Does anyone have any ideas?

codemaster
Junior Member

posted March 07, 2000 05:57 PM

Here is how I did it:
<SELECT NAME="category">
<?
mysql_pconnect("localhost","user","pass") or die ("unable to connect");
mysql_select_db("yourdb") or die ("cannot select db");
$opt_sql = "SELECT whatever FROM yourtable";
$opt_1 = mysql_query($opt_sql);
while($opt_2 = mysql_fetch_row($opt_1)) {
echo "<OPTION VALUE=\"" . $opt_2[0] . "\">" . $opt_2[0] . "</OPTION>\n";
}
mysql_free_result($opt_1);

?>
</SELECT>

Hope this helps.

quote:
Originally posted by bbrown:
Id like to load a drop down list from a mysql database using php3 and create a link to that record. Does anyone have any ideas?

All times are MST (US)	next newest topic \| next oldest topic
Administrative Options: Close Topic \| Archive/Move \| Delete Topic
	Hop to:

Contact Us | DevShed.com