帝国CMS二次开发调用评论我的列表

帝国CMS调用评论我的列表查询代码

$totalquery="selectcount(*)astotalfrom{$dbtbpre}enewspl_1".$a;
$num=$empire->gettotal($totalquery);
$query="select*from{$dbtbpre}enewspl_1".$a;
$query.="orderbypliddesclimit$offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);

<?php
while($r=$empire->fetch($sql)){
$t1=$empire->query("select * from{$dbtbpre}ecms_news where id='$r[id]' and classid='$r[classid]' and userid='$user[userid]' order by '$sql1[saytime]' desc limit 8");
		while($r11=$empire->fetch($t1)){
?>
	<trbgcolor="#FFFFFF">
<td height="25"><div align="left"><a class="key_word" href="[!--news.url--]e/space/?userid=<?=$r[userid]?>" target="_blank"><?=$r[username]?></a>:<?=$r[saytext]?></div></td>
<td height="25"><div align="center"><a class="key_word" href="<?=$r11[titleurl]?>" target="_blank"><?=$r11[title]?></a></div></td>
<td height="25"><div align="center"><?=date('Y-m-dH:i:s',$r[saytime])?></div></td>
</tr>
<?php
}}
?>