帝国CMS调用评论的文章链接和文章标题的方法

<?
$sql=$empire->query("select * from {$dbtbpre}enewspl_1 where id='$navinfor[id]' and checked=0 order by saytime limit 10");
$userr=sys_ShowMemberInfo(0,'');
while($r=$empire->fetch($sql))   //循环获取查询记录
{
        $q=$empire->fetch1("select title,titleurl from {$dbtbpre}ecms_news where id='$r[id]' limit 1");
?>
栏目id：<?=$r[classid]?>
文章id：<?=$r[id]?>
用户名：<?=$r[username]?>  
评论内容<?=$r['saytext']?>
标题：<?=$q[title]?>
链接：<?=$q[titleurl]?>
<?
}
?>