大家是不是这样取商品分类-PHP教程,PHP应用

php代码:——————————————————————————–

// 取商品分类

//**************************************************************************

$result=$db->query("select * from categories where categories_parent_id=0 order by categories_sort_order");

while($row=$db->fetch_array($result))

{

$categories.=$row[categories_name]."<br>";

$result2=$db->query("select * from categories where categories_parent_id=$row[categories_id] order by categories_sort_order");

while($row2=$db->fetch_array($result2))

{

$categories.=$row2[categories_name]."/";

}

$categories.="<br><br>";

}

//**************************************************************************