INSERT INTO `wuxianfenji` (`id`, `pid`, `catename`, `cateorder`, `createtime`)
VALUES
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國內新聞',0,0),
(4,1,'國際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風景圖片',0,0),
(9,7,'日韓明星',0,0),
(10,9,'日本AV',0,0);
VALUES
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國內新聞',0,0),
(4,1,'國際新聞',0,0),
(5,3,'北京新聞',0,0),
(6,4,'美國新聞',0,0),
(7,2,'美女圖片',0,0),
(8,2,'風景圖片',0,0),
(9,7,'日韓明星',0,0),
(10,9,'日本AV',0,0);
2017-03-06
新手看這里:查詢語句這個比較完整,不然會出錯的
$sql="select id,catename,path,concat(path, ',' ,id) as fullpath from likecate where 1 order by fullpath asc";
$sql="select id,catename,path,concat(path, ',' ,id) as fullpath from likecate where 1 order by fullpath asc";
2017-02-22
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in
2017-02-04
getList(arg1,arg2){} 第一參數為零,表示頂級菜單,,然后把這條記錄獲取出來,然后獲取其id 傳給自身函數調用,第二次調用,就把pid 等于第一條取出來的id值,的子類菜單,都取出來,一一遍歷穿進去數組,返回出來!~~
2017-01-08