数据表准备:
CREATE TABLE `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT NULL,
`postuser` varchar(10) DEFAULT NULL,
`postdate` datetime DEFAULT NULL,
`parentid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
数据准备:
INSERT INTO `articles` VALUES ('1', '第一条帖子', '张三', '1998-10-10 12:32:32', null);
INSERT INTO `articles` VALUES ('2', '第二条帖子', '张三', '1998-10-10 12:34:32', null);
INSERT INTO `articles` VALUES ('3', '第一条回复1', '李四', '1998-10-10 12:35:32', '1');
INSERT INTO `articles` VALUES ('4', '第二条回复1', '李四', '1998-10-10 12:36:32', '2');
INSERT INTO `articles` VALUES (&#