$totalquery="select count(*) as total from {$dbtbpre}enewspl_1 where username='$user[username]'".$a; $num=$empire->gettotal($totalquery); $query="select * from {$dbtbpre}enewspl_1 where username='$user[username]'".$a; $query.=" order by plid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page1($num,$line,$page_line,$start,$page,$search);
<?php while($r=$empire->fetch($sql)){ $t=$empire->fetch1("select * from {$dbtbpre}ecms_news where id='$r[id]' and classid='$r[classid]'"); ?> <tr bgcolor="#FFFFFF"> <td height="25"> <p align="left"><?=$r[saytext]?></p></td> <td height="25"> <p align="center"> <a class="key_word" href="<?=$t[titleurl]?>" target="_blank"><?=$t[title]?></a></p></td> <td height="25"> <p align="center"><?=date('Y-m-d H:i:s',$r[saytime])?></p></td> </tr> <?php } ?>
版權(quán)聲明: 本站資源均來自互聯(lián)網(wǎng)或會(huì)員發(fā)布,如果侵犯了您的權(quán)益請與我們聯(lián)系,我們將在24小時(shí)內(nèi)刪除!謝謝!
轉(zhuǎn)載請注明: 帝國CMS二次開發(fā)會(huì)員中心調(diào)用評論列表