query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//活动一级分类 注意在这顶级分类id为 59
function getflone($flpid){
global $db;
$sql=select * from fenlei where flpid={$flpid} order by flid;
$rs=$db->query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//活动二级分类
function getfltwo($flpid){
global $db;
$sql=select * from fenlei where flpid={$flpid} order by flid;
$rs=$db->query($sql);
$data=array();
while ($row=$db->fetch_array($rs)){
$data[]=$row;
}
return $data;
}
//循环获取菜单,此数据库顶级父分类id为 59
function getflmenu($flpid){
global $db;
$arr=getflone($flpid);
foreach ($arr as &$v) {
$arrt=getflone($v[flid]);
foreach ($arrt as &$vl){
$arrtt=getflone($vl[flid]);
$vl[tt]=$arrtt;
}
$v[two]=$arrt;
}
return $arr;
}
?>
array
(
[0] => array
(
[0] => 93
[flid] => 93
[1] => 59
[flpid] => 59
[2] => 国内新闻
[fltitle] => 国内新闻
[3] => 0-59
[flpath] => 0-59
[4] => 国内新闻
[fldes] => 国内新闻
[5] => 国内新闻
[keyword] => 国内新闻
[two] => array
(
[0] => array
(
[0] => 98
[flid] => 98
[1] => 93
[flpid] => 93
[2] => 时政
[fltitle] => 时政 本文链接http://www.cxybl.com/html/wlbc/php/20121120/34051.html