PHP 在一张mysql表中嵌套查询（即二级目录）

理想
'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" title="Click Here To EnLarge">我的
'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" title="Click Here To EnLarge">这是PHP 源码：
$sql="SELECT * FROM `yhzy_pro_cat` where pid=0";
$query=$db->query($sql);
while($row_class=mysql_fetch_array($query)){      //////嵌套循环一层
     $sm_class[]=array("name"=>$row_class[nc_name],"id"=>$row_class[nc_id]);
    $sql="SELECT * FROM `yhzy_pro_cat` where pid=$row_class[nc_id]";
    $qus=$db->query($sql);        
    while($row_cs=mysql_fetch_array($qus)){//////嵌套循环二层
        $sm_cls[]=array("name"=>$row_cs[name],"id"=>$row_cs[id]);        
     }
}   print_r($sm_cls);
            $smarty->assign("sm_class",$sm_class);//导航引入
           $smarty->assign("sm_classs",$sm_cls);


可是在页面上显二级目录是：Array ( [0] => Array ( [name] => [id] => ) [1] => Array ( [name] => [id] => ) [2] => Array ( [name] => [id] => ) [3] => Array ( [name] => [id] => ) [4] => Array ( [name] => [id] => ) [5] => Array ( [name] => [id] => ) [6] => Array ( [name] => [id] => ) [7] => Array ( [name] => [id] => ) [8] => Array ( [name] => [id] => ) [9] => Array ( [name] => [id] => ) [10] => Array ( [name] => [id] => ) ) 这是什么问题呢？请高手帮个忙！谢谢！

解决了！嘎嘎！还得自己细心点呀！嘎嘎！

不过又出现问题了!呜呜呜！

     $sql="SELECT * FROM `yhzy_pro_cat` where pid=0";
$query=$db->query($sql);
while($row_class=mysql_fetch_array($query)){      //////嵌套循环一层
     $sm_class[]=array("name"=>$row_class[nc_name],"id"=>$row_class[nc_id]);
    $sql="SELECT * FROM `yhzy_pro_cat` where pid=$row_class[nc_id]";
    $qus=$db->query($sql);        
    while($row_cs=mysql_fetch_array($qus)){//////嵌套循环二层
        $sm_cls[]=array("name"=>$row_cs[nc_name],"id"=>$row_cs[nc_id]);        
     }
}   print_r($sm_cls);
            $smarty->assign("sm_class",$sm_class);//导航引入
           $smarty->assign("sm_classs",$sm_cls);
    这是改完之后的，但是现在的问题是所有的二级目录都在每一个一级目录下出现了！
如图
'700')this.width='700';if(this.offsetHeight>'700')this.height='700';" title="Click Here To EnLarge">

请高手帮个忙呀！小弟非常感谢！

<?php

$sql="SELECT * FROM `yhzy_pro_cat` where pid=0";
$query=$db->query($sql);
while($row_class=mysql_fetch_array($query)){      //////嵌套循环一层
    $sm_class[]=array("name"=>$row_class[nc_name],"id"=>$row_class[nc_id]);
    $sql="SELECT * FROM `yhzy_pro_cat` where pid=$row_class[nc_id]";
    $qus=$db->query($sql);        
        while($row_cs=mysql_fetch_array($qus)){ //////嵌套循环二层
            $sm_cls[]=array("name"=>$row_cs[nc_name],"id"=>$row_cs[nc_id]);        
        }
}   print_r($sm_cls);
    $smarty->assign("sm_class",$sm_class);//导航引入
    $smarty->assign("sm_classs",$sm_cls);
?>

我整理了一下，慢慢看。。

我没找问题

$row_class[nc_id] 你检查下你这个值，，，应该是它没有取到。。

你看下SQL语句是不是应该这样调 。。

他应该取到了！
$sql="SELECT * FROM `yhzy_pro_cat` where pid=0";
$query=$db->query($sql);
while($row_class=mysql_fetch_array($query)){      //////嵌套循环一层
     $sm_class[]=array("name"=>$row_class[nc_name],"id"=>$row_class[nc_id]);
    echo $row_class[nc_id];echo "!!!!";
    $sql="SELECT * FROM `yhzy_pro_cat` where pid=$row_class[nc_id]";
    $qus=$db->query($sql);        
    while($row_cs=mysql_fetch_array($qus)){//////嵌套循环二层
        $sm_cls[]=array("name"=>$row_cs[nc_name],"id"=>$row_cs[nc_id]);        
     }
}   print_r($sm_cls);
            $smarty->assign("sm_class",$sm_class);//导航引入
           $smarty->assign("sm_classs",$sm_cls);
    
    我在屏幕上输出：1!!!!2!!!!12!!!!13!!!!18!!!!19!!!!20!!!!21!!!!22!!!!23!!!!24!!!!25!!!!Array ( [0] => Array ( [name] => 电脑 [id] => 3 ) [1] => Array ( [name] => MP3/MP4 [id] => 6 ) [2] => Array ( [name] => 数码相机 [id] => 7 ) [3] => Array ( [name] => 数字电视 [id] => 8 ) [4] => Array ( [name] => 洗发水 [id] => 9 ) [5] => Array ( [name] => 卫生纸 [id] => 10 ) [6] => Array ( [name] => 沐浴露 [id] => 11 ) [7] => Array ( [name] => 风驰静界系列 [id] => 14 ) [8] => Array ( [name] => 后免拆洗系列 [id] => 15 ) [9] => Array ( [name] => 典爱世纪系列 [id] => 16 ) [10] => Array ( [name] => 双核净界系列 [id] => 17 ) )

请问一下难道是html代码问题吗？
{section name=l loop=$sm_class}
        <TR>
          <TD class=Menu1 width=12><IMG src="{$t_dir}images/ioc1.gif" width=9></TD>
          <TD class=Menu1><A title={$sm_class[l].name}
            href=" "><B>{$sm_class[l].name}>></B></A></TD></TR>
       {section name=k loop=$sm_classs}
        <TR>
          <TD class=Menu1> </TD>
          <TD class=Menu1><A
            href=" "> {$sm_classs[k].name}</A></TD></TR>
            
            {/section}
            {/section}