SQL语句:select a.id,a.classid,a.title,a.titlepic,a.username,a.userid,a.applynum,a.onclick,a.titleurl,b.id,b.classid,count(b.id) fromphome_ecms_news as a left join phone_enewsfava as b on a.id=b.id and a.classid=b.classid where…
如题,会员空间反馈信息调用。代码如下:<?
//会员空间反馈 调用
//userid='1' 会员ID
$sql=$empire->query("select ftext,uname,uid from {$dbtbpre}enewsmemberfeedback where userid='1' order by fid desc limit 8");
while($…
SQL语句调用要指定终极栏目ID,如果不想手动指定多个终极栏目ID,可以用下面方法:select * from [!db.pre!]ecms_news where checked=1 and ".($class_r[$GLOBALS[navclassid]][islast]?"classid='$GLOBALS[navclassid]'":ReturnClass($clas…
用:select * from phome_enewsad where adid in (广告ID1,广告ID2,....)实例:[e:loop={"select * from phome_enewsad where adid in (1,2,3) and t=0 order by adid desc limit 20",0,24}]
<a href="<?=$bqr[url]?>" target="_blank" title…