已采納回答 / 慕田峪8963383
static 是靜態(tài)屬性,在內存中運行的,會把結果依次保存。getList($mysqlli,$row['id'])這樣調用就ok,不用把$result寫進去,結果數組也可用array_merge() 合并,盡量不要用static 有副作用
2017-03-18
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