帝国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);

前台展示代码

 

<?phpwhile($r=$empire->fetch($sql)){$t1=$empire->query("select*from{$dbtbpre}ecms_newswhereid='$r[id]'andclassid='$r[classid]'anduserid='$user[userid]'orderby'$sql1[saytime]'desclimit8");while($r11=$empire->fetch($t1)){?><trbgcolor="#FFFFFF"><tdheight="25"><palign="left"><aclass="key_word"href="[!--news.url--]e/space/?userid=<?=$r[userid]?>"target="_blank"><?=$r[username]?></a>:<?=$r[saytext]?></p></td><tdheight="25"><palign="center"><aclass="key_word"href="<?=$r11[titleurl]?>"target="_blank"><?=$r11[title]?></a></p></td><tdheight="25"><palign="center"><?=date('Y-m-dH:i:s',$r[saytime])?></p></td></tr><?php}}?>