代碼無法插入???
INSERT INTO 'deepcate'(`id`, `pid`, `catename`, `cateorder`, `createtime`)VALUES
(1,0,"新聞",0,0),
(1,0,'新聞',0,0),
(2,0,'圖片',0,0),
(3,1,'國內(nèi)新聞',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),
(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,'國內(nèi)新聞',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),
(9,9,'日本AV',0,0);
2016-02-11
while($row=mysql_fetch_assoc($res))
{$row['catename'] = str_repeat(' ',$spac) . '|--' . $row['catename'];
$result[] = $row;
getList($row['id'],$result,$spac);
}
return $result;
}
$rs = getList();
print_r($rs);
?>
{$row['catename'] = str_repeat(' ',$spac) . '|--' . $row['catename'];
$result[] = $row;
getList($row['id'],$result,$spac);
}
return $result;
}
$rs = getList();
print_r($rs);
?>
2015-12-08
<?php
funtion getList($pid=0,&$result=array(),$spac=0){
$spac = $spac + 2;
$sql="SELECT * FROM deepcate WHERE pid = $pid";
$res= mysql_query($sql);
funtion getList($pid=0,&$result=array(),$spac=0){
$spac = $spac + 2;
$sql="SELECT * FROM deepcate WHERE pid = $pid";
$res= mysql_query($sql);
2015-12-08