通过数据库获得博客该文章分类下的其他文章

//获得相关文章,参数1为分类id,参数2为显示条数.都不是必须的参数,默认显示未分类的6条数据

function getgxtext($fenlei,$shuliang){

$fl = isset($fenlei) ? $fenlei : -1;

$sl = isset($shuliang) ? $shuliang : 6;

$db = MySql::getInstance();

$sql = "SELECT * FROM ".DB_PREFIX."blog WHERE  hide='n' and checked='y' and sortid = ".$fl." order by gid desc limit ".$sl."";

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

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

echo "

".subString($row['title'],0,30)."

";

}

}

?>