大家是不是这样取商品分类
类别: 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>";
}
//**************************************************************************
// 取商品分类
//**************************************************************************
$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>";
}
//**************************************************************************
- 上一篇: 转帖：PHP4(windows版本)中的COM函数
- 下一篇: PHP常见问题
