rendered paste body<?php
$forumlist = mysql_fetch_array(mysql_query('SELECT * FROM `forum` LIMIT 0, 10'));
echo '<pre>';var_dump($forumlist);echo '</pre>';
?>
CREATE TABLE `forum` (
`forumid` int(11) NOT NULL auto_increment,
`forumtitle` varchar(100) NOT NULL default '',
`forumdesc` varchar(250) NOT NULL default '',
`displayorder` smallint(6) NOT NULL default '0',
`threadcount` int(11) NOT NULL default '0',
`postcount` int(11) NOT NULL default '0',
`lastpost` int(11) NOT NULL default '0',
`lastthread` varchar(250) NOT NULL default '',
`lastposter` varchar(50) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '-1',
PRIMARY KEY (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `forum`
--
INSERT INTO `forum` VALUES (1, 'Category', '', 0, 0, 0, 0, '', '', -1);
INSERT INTO `forum` VALUES (2, 'Forum', 'Description sample', 0, 0, 0, 0, '', '', 1);
INSERT INTO `forum` VALUES (3, 'Category', '', 0, 0, 0, 0, '', '', -1);