//獲得相關(guān)文章,有兩個參數(shù),分別是文章分類和顯示條數(shù).如果參數(shù)沒有寫的話,默認分類為未分類,顯示條數(shù)為6條
function getgxtext($fenlei,$shuliang){
$fl = isset($fenlei) ? $fenlei : -1;
$sl = isset($shuliang) ? $shuliang : 6;
$db = MySql::getInstance();
//獲得所有子分類
$sql = "SELECT * FROM ".DB_PREFIX."sort WHERE pid = ".$fl;
$subsort = '';
$sql = $db->query($sql);
while($row = $db->fetch_array($sql)){
$subsort .= ' or sortid = '.$row['sid'];
}
//echo '子分類為:'.$subsort;
$sql = "SELECT * FROM ".DB_PREFIX."blog WHERE ?hide='n' and checked='y' and (sortid = ".$fl.$subsort.") order by gid desc limit ".$sl."";
return $db->query($sql);
}
?>
