最后二次开发完成后的效果
帝国CMS调用关注我的列表查询代码
$totalquery="select count(*) as total from {$dbtbpre}enewshy where fname='$username'".$a; $num=$empire->gettotal($totalquery); $query="select * from {$dbtbpre}enewshy where fname='$user[username]'".$a; $query.=" order by fid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page1($num,$line,$page_line,$start,$page,$search);
前台展示代码
<?php while($r=$empire->fetch($sql)){ $fuaddr=$empire->fetch1("select userpic,fax from {$dbtbpre}enewsmemberadd where userid='$r[userid]' limit 1"); $fuaddr2=$empire->fetch1("select userfen,username from {$dbtbpre}enewsmember where userid='$r[userid]' limit 1"); ?>
" target="_blank"><?=$fuaddr2[username]?>
性别:<?=$fuaddr[fax]?> 积分:<?=$fuaddr2[userfen]?>