insert into likecate (id,path,catename,cateorder,createtime) values
(1,'','手機(jī)',0,0),
(2,'1','功能手機(jī)',0,0),
(3,'1,2','老人手機(jī)',0,0),
(4,'1,2','兒童手機(jī)',0,0),
(5,'1','智能手機(jī)',0,0),
(6,'1,5','android手機(jī)',0,0),
(7,'1,5','IOS手機(jī)',0,0),
(8,'1,5','WinPhote手機(jī)',0,0),
(9,'1,2,4','色盲手機(jī)',0,0),
(10,'1,2,3','大字手機(jī)',0,0)
;
(1,'','手機(jī)',0,0),
(2,'1','功能手機(jī)',0,0),
(3,'1,2','老人手機(jī)',0,0),
(4,'1,2','兒童手機(jī)',0,0),
(5,'1','智能手機(jī)',0,0),
(6,'1,5','android手機(jī)',0,0),
(7,'1,5','IOS手機(jī)',0,0),
(8,'1,5','WinPhote手機(jī)',0,0),
(9,'1,2,4','色盲手機(jī)',0,0),
(10,'1,2,3','大字手機(jī)',0,0)
;
2016-05-05
表單數(shù)據(jù):
insert into fenlei(id,pid,catename,cateorder,createtime) values
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國(guó)內(nèi)新聞',0,0),
(4,1,'國(guó)際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國(guó)新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(10,9,'大陸明星',0,0);
insert into fenlei(id,pid,catename,cateorder,createtime) values
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國(guó)內(nèi)新聞',0,0),
(4,1,'國(guó)際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國(guó)新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(10,9,'大陸明星',0,0);
2016-04-14
創(chuàng)建表: create table fenlei(
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
id int unsigned not null auto_increment primary key,
pid int unsigned not null,
catename varchar(30) not null,
cateorder int unsigned not null,
createtime int(10) not null
);
2016-04-14
代碼就是一行,利用id查到pid,再用pid去查.ps pid就是上級(jí)的ID
2016-04-01
最新回答 / 幕布斯3915397
function getList($pid=0,&$result=array(),$spac=0)想改變哪個(gè)參數(shù)?就該實(shí)參啊.
2016-03-29
代碼無(wú)法插入???
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新聞",0,0),
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國(guó)內(nèi)新聞',0,0),
(4,1,'國(guó)際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國(guó)新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(9,9,'日本AV',0,0);
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新聞",0,0),
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國(guó)內(nèi)新聞',0,0),
(4,1,'國(guó)際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國(guó)新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風(fēng)景圖片',0,0),
(9,7,'日韓明星',0,0),
(9,9,'日本AV',0,0);
2016-02-11