如何只查询二级类别？

Question

这是我的代码，它显示所有类别，例如

一个
-A.1
-A.2
B
-B.1
-B.2

现在我希望它只显示

<块引用>

A.1
A.2
B.1
B.2

有什么想法吗？

    function current_categories($m,$id){
    $cat_array=array();
    $sql = "select * from `category`";
    $query = DB::Query($sql);
        while($row = DB::fetch_array($query)){
            $cat_array[] = array($row['id'],$row['name'],$row['classid'],$row['sort']);
        } 
        if($id==""){
            $id=0;
        }
    $n = str_pad('',$m,'-',STR_PAD_LEFT);
    $n = str_replace("-","    ",$n);
    for($i=0;$i<count($cat_array);$i++){
        if($cat_array[$i][2]==$id){
        echo "<li>"."<a href=\"/team/index.php?gid=".$cat_array[$i][0]."\">".$cat_array[$i][1]."</a></li>"; 
    current_categories($m+2,$cat_array[$i][0]);
        }
    }
}

Answer 1

我不知道您为顶级 classid 值输入什么值作为 classid 。也许是 NULL 或 -1？

function second_level_categories(){
    $sql = " SELECT lvl2.* FROM `category` as lvl1 "
          ." JOIN `category` as lvl2"
          ."     ON lvl1.id = lvl2.parent_id"
          ." WHERE lvl1.parent_id=VALUE_FOR_TOP_LEVEL"
          ." ORDER BY lvl1.sort ASC, lvl2.sort ASC"

    $result = DB::Query($sql);
    while($category = DB::fetch_array($result)){
        echo '<li><a href="/team/index.php?gid='.$category['id'].'">"';
        echo $category['name'];
        echo '</a></li>';
    } 
}