MySQL Dump for PHP examples

This is a sample MySQL data that we will use in several of our examples



CREATE TABLE `test` (
`id` int(4) NOT NULL auto_increment,
`cat` varchar(10) NOT NULL default '',
`url` varchar(50) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`desc` varchar(100) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=10;

#
# Dumping data for table `test`
#

INSERT INTO `test` VALUES (1, 'search', 'http://www.google.com', 'google', 'The best search engine and directory');
INSERT INTO `test` VALUES (2, 'search', 'http://yahoo.com', 'yahoo', 'The mighty yahoo');
INSERT INTO `test` VALUES (3, 'programming', 'http://www.programmershelp.co.uk', 'programmershelp', 'Various programming resources');
INSERT INTO `test` VALUES (4, 'programming', 'http://www.programmershelp.net', 'Programmers Help', 'Programmers Help');
INSERT INTO `test` VALUES (5, 'programming', 'http://www.beginnersphp.co.uk', 'Beginners PHP', 'Beginners PHP site');
INSERT INTO `test` VALUES (6, 'misc', 'http://www.maxidirectory.com', 'Maxi directory', 'maxi directory');
INSERT INTO `test` VALUES (7, 'misc', 'http://www.holed.net', 'Holed golf', 'Holed golf');
INSERT INTO `test` VALUES (8, 'misc', 'http://www.worldipod.com', 'DWorld Ipod', 'All about the IPod and Iphone');
INSERT INTO `test` VALUES (9, 'misc', 'http://www.acaiplace.info', 'Acai Place', 'Acai information');