帝国cms完整的sql语句写法

2018-10-11 11:03:22 围观 :

<?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
}
?>
    匿名评论
  • 评论
人参与,条评论

相关文章

    无相关信息
网站分类