![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
用chilly的无限分类代码写了一点东西,但是被循环中的循环给卡住了,我想把二级分类和分类里边的内容列表循环显示出来(看附件),想了几天都没有结果,请各路高手帮忙,谢谢。[PHP] 数据表的结构 `mf_sort`
#
CREATE TABLE mf_sort (
sortid smallint(3) unsigned NOT NULL auto_increment,
main tinyint(2) unsigned NOT NULL default '0',
parentid smallint(3) unsigned NOT NULL default '0',
layer smallint(3) unsigned NOT NULL default '0',
orders tinyint(2) unsigned NOT NULL default '0',
sort varchar(100) NOT NULL default '',
description varchar(250) NOT NULL default '',
admin varchar(16) NOT NULL default '',
PRIMARY KEY (sortid),
KEY main (main,parentid,layer,orders)
) TYPE=MyISAM;
数据表的结构 `topic`
#
CREATE TABLE topic (
postid int(10) unsigned NOT NULL auto_increment,
topicid int(10) unsigned NOT NULL default '0',
icon varchar(100) NOT NULL default '0',
title varchar(100) NOT NULL default '',
message mediumtext NOT NULL,
lastpost int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
replyicon varchar(200) NOT NULL default '',
replycount int(10) unsigned NOT NULL default '0',
sticky smallint(6) NOT NULL default '0',
postusername varchar(50) NOT NULL default '',
postuserid int(10) unsigned NOT NULL default '0',
lastposter varchar(50) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
views int(10) unsigned NOT NULL default '0',
iconid smallint(5) unsigned NOT NULL default '0',
attach smallint(5) unsigned NOT NULL default '0',
mark tinyint(2) NOT NULL default '0',
PRIMARY KEY (postid),
KEY iconid (iconid),
KEY forumid (forumid,lastpost)
) TYPE=MyISAM;
[/PHP]

