帝国cms完整的sql语句写法

2024-08-28 12:25:04

字体：大中小

来源：转载

供稿：网友

<?php
$sql=$empire->query("select a.*,b.* from phome_ecms_dt as a LEFT JOIN phome_enewsmemberadd as b ON a.userid=b.userid where a.userid='$userid' order by newstime desc limit 100");
while($r=$empire->fetch($sql))
{
$titleurl=sys_ReturnBqTitleLink($r);//链接
?>
<div class="view-dynamic plpr20 mt20 bgfff pt20">
<div class="con pb30">
<div class="info"><a href="UserInfo.php?userid=<?=$userid?>">
<img src="<?=$userpic?>" alt="" class="fl"></a>
<div class="txt p_r">
<div class="name f24"><?=$username?><em class="di_in ml10"></em></div>
<p class="c999 f20"><?=$r['pro']?> | <?=date("Y",time())-$r[year]?>岁 | <?=$r['edu']?></p>
</div>
</div>
<div class="box">
<div class="f24 c333 mt15"><?=$r[title]?></div>
</div>
<div class="time mt30">
<span class="fl c999 f20"><?=date('Y-m-d',$r[newstime])?></span>
<a href="" class="fl f20 ml30 del">删除</a>
<a href="" class="fr book di_in ml30 c999 f20"><?=$r[plnum]?></a>
<a href="" class="di_in zai fr c999 f20"><?=$r[onclick]?></a>
</div>
</div>
</div>
<?php
}
?>

上一篇：帝国CMS列表内容模板(list.var)调用会员头像会员名会员积分

下一篇：帝国CMS会员退出后跳转到指定地址的方法