很早很早很早写的一个递归,还是用过程写的,有着纪念的意义啊.....
mysql_connect("localhost","root","2765237");
mysql_select_db("phpbbs");
mysql_set_charset("gbk");
$sql="select * from `bbs_class` where lv_class_id=0";
$query=mysql_query($sql);
while ($rs=mysql_fetch_array($query))
{
$result[]=$rs;
}
function aaa($num)
{
mysql_connect("localhost","root","2765237");
mysql_select_db("phpbbs");
mysql_set_charset("gbk");
$sql="select * from `bbs_class` where lv_class_id='".$num."'";
$query=mysql_query($sql);
while ($rs=mysql_fetch_array($query))
{
$result[]=$rs;
}
$nums=mysql_num_rows($query);
if($nums==0)
{
return false;
}
foreach ($result as $val)
{
echo $val['class_name']."
";
aaa($val['id']);
}
}
foreach ($result as $val)
{
echo $val['class_name']."
";
aaa($val['id']);
}
?>