帝国CMS二次开发会员中心调用评论列表

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

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

前台展示代码

<?phpwhile($r=$empire->fetch($sql)){$t=$empire->fetch1("select*from{$dbtbpre}ecms_newswhereid='$r[id]'andclassid='$r[classid]'");?><trbgcolor="#FFFFFF"><tdheight="25"><divalign="left"><?=$r[saytext]?></div></td><tdheight="25"><divalign="center"><aclass="key_word"href="<?=$t[titleurl]?>"target="_blank"><?=$t[title]?></a></div></td><tdheight="25"><divalign="center"><?=date('Y-m-dH:i:s',$r[saytime])?></div></td></tr><?php}?>