Ik wil op de startpagina van mijn forum een overzicht maken met actieve topics (25 maximaal)
Aangezien er bij iedere reply een datum wordt meegegeven dacht ik dit te kunnen filteren op deze data maar kom er niet helemaal uit hoe ik dit kan realiseren. Zou iemand mij kunnen vertellen hoe ik dit kan doen met deze structuur?
PHP
--
-- Table structure for table `forumtopics`
--
CREATE TABLE IF NOT EXISTS `forumtopics` (
`id` int(255) NOT NULL auto_increment,
`title` varchar(40) character set latin1 default NULL,
`content` text character set latin1,
`auteur` varchar(25) character set latin1 default NULL,
`smiles` int(5) NOT NULL default '1',
`ubb` int(5) NOT NULL default '1',
`link` int(5) NOT NULL default '1',
`subforum` int(5) NOT NULL default '0',
`read` int(5) NOT NULL default '0',
`lastreply` varchar(25) character set latin1 default NULL,
`lastreplydate` varchar(20) character set latin1 default NULL,
`date` varchar(20) character set latin1 default NULL,
`reacties` int(5) NOT NULL default '0',
`categorie` varchar(60) character set latin1 NOT NULL default 'topic',
`locked` int(5) NOT NULL default '0',
`moved` int(5) NOT NULL default '0',
`lastreplydate2` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=21 ;
--
-- Dumping data for table `forumtopics`
--
INSERT INTO `forumtopics` (`id`, `title`, `content`, `auteur`, `smiles`, `ubb`, `link`, `subforum`, `read`, `lastreply`, `lastreplydate`, `date`, `reacties`, `categorie`, `locked`, `moved`, `lastreplydate2`) VALUES
(17, 'Welcome Page', ' :geek: ', 'admin', 1, 1, 1, 5, 0, 'admin', '27-06-2010', '27-06-2010 18:01', 0, 'topic', 0, 0, '2010-06-27 18:01:52'),
(19, 'Welcome Page', ' :geek: ', 'admin', 1, 1, 1, 5, 0, 'admin', '28-06-2010', '27-06-2010 18:02', 0, 'topic', 0, 0, '2010-06-28 11:47:37'),
(20, 'Welcome Page', ' :geek: ', 'admin', 1, 1, 1, 5, 0, 'admin', '27-06-2010', '27-06-2010 18:02', 0, 'topic', 0, 0, '2010-06-27 18:02:49');Opgelost:
PHP
$topic2 = mysql_query("SELECT * FROM `forumtopics` ORDER BY `lastreplydate2` DESC LIMIT 0,20");
while($topic = mysql_fetch_object($topic2)){
$user2 = mysql_query("SELECT * FROM `users` WHERE `login`='$topic->lastreply'");
$user = mysql_fetch_object($user2);
$schammel = mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `login`='$user->login'");