mysql 获取子分类_Emlog531获取指定分类的子分类信息

//获得指定分类的子分类,参数为分类ID

function getsubcategoryinfo($categoryid){

$db = MySql::getInstance();

$sortid = intval($categoryid) ? $categoryid : -1;

$sql = "SELECT * FROM ".DB_PREFIX."sort WHERE pid = ".$sortid;

$sql = $db->query($sql);

$result = array();

$i = 0;

while($row = $db->fetch_array($sql)){

$result[$i]['sid'] = $row['sid'];

$result[$i]['sortname'] = $row['sortname'];

$result[$i]['alias'] = $row['alias'];

$result[$i]['taxis'] = $row['taxis'];

$result[$i]['pid'] = $row['pid'];

$result[$i]['description'] = $row['description'];

$result[$i]['template'] = $row['template'];

$i++;

}

return $result;

}

?>

数组输出每个子分类的id，名称，别名，序号，父分类id，分类描述和分类模板