//獲得相關(guān)文章,有兩個(gè)參數(shù),分別是文章分類和顯示條數(shù).如果參數(shù)沒有寫的話,默認(rèn)分類為未分類,顯示條數(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);

}

?>