Mega Code Archive
Populate a select menu from a MySQL database
<![CDATA[
<?php
/*
Database info below, database name is categories
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
#
# Dumping data for table `categories`
#
INSERT INTO `categories` VALUES (1, 'php');
INSERT INTO `categories` VALUES (2, 'asp');
INSERT INTO `categories` VALUES (3, 'javascript');
INSERT INTO `categories` VALUES (4, 'visual basic');
INSERT INTO `categories` VALUES (5, 'javascript');
*/
$connection = mysql_connect ("localhost","username", "password");
$db = mysql_select_db ("categories",$connection);
function listCat()
{
$sql_query = mysql_query("SELECT category, id FROM categories");
echo "<select name=\"id\">";
while(list($catname, $catid)=mysql_fetch_array($sql_query))
{
$catname = stripslashes($catname);
echo "<option value=\"$catid\">$catname</option>";
}
echo "</select>";
mysql_free_result($sql_query);
}
echo "<form method=\"post\" action\"\">
Select:";
listCat();
echo "<input type=\"Submit\" Value=\"Submit\">
</form>";
?>
]]>