Navigation :
HomeSource code
Tutorials
RSS feeds
Articles
Wordpress plugins
Books
Sample Chapters
Software
Downloads
Hosting
manuals
Script directory
Training
Our Links
Site Sponsors :
Bookmark :
Links :
domain namesgolfing products
dropshippers
Downloads :
dzphp editorEasyPHP
mysql_phpgenerator
php-studio-trial
phpdesigner_7_2_5
phpMyAdmin-3.4.3.2
/phptriad2-2-1
phpxedit_321
rapidphp 2011
WampServer2.1d-x64
WampServer2.1e-x32
xampp-win32-1.7.4-VC6-installer
xampplite-win32-1.7.3
Misc :
Webmaster ResourcesOnly PHP
ScriptSearch.com
Scripts.com - Get the best scripts NOW!
AndreaPHP Programming
populate a select menu from MySQL
populate a select menu from a MySQL database
<?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>";
?>
Books :
Sponsors :
Random Code :
Random daily background colour(randomizing)Output a number with leading zeroes(math)
highlighting source code(beginner)
Random Article :
how to implement a simple cms using PHP and MySQLProtecting your HTML and PHP Source Code
Network:
Programming resourcesTutorials directory
Hosting resources
ASP site
Domain names
Progged
Maxi directory
bigarticle : free articles
A Code
Code N Tutorials
Get PHP
Programmers help
Del.icio.us
Digg
Furl
Newsvine
Netscape
Reddit
StumbleUpon
Technorati
Squidoo
Windows Live
Yahoo MyWeb
Ask
Google

