帝国cms完整的sql语句写法
2018-10-11 站长 站长日志
<?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 } ?> |