以下就是万能标签调用的方式,其他标签方法一样[ecmsinfo]"select * from [!db.pre!]ecms_article where clasid=2 and istop=5 order by newstime desc limit 8",8,20,0,24,34,0[/ecmsinfo]
以下代码就是调用多个父栏目信息的调用代码select * from [!db.pre!]ecms_news where clasid in (select clasid from [!db.pre!]enewsclas where bclasid in (7,8,9)) order by onclick DESC limit 8
多表查询+多表标题链接的调用[e:loop={ select a.*,b.gsjc from phome_ecms_news a LEFT JOIN phome_ecms_gsj b on a.gsid=b.id where a.clasid in (8) order by a.newstime desc limit 1,5,24,0}]以上A为第一个
打开e/data/template/loginiframetemp.txt 在$r=$empirefetch1(select .$user_userid.,.$user_username.,.$user_group.,.$user_userfen.,.$user_money.,.$user_userdate.,.$user_havemsg.,.$user_checked. from .$us
[e:loop={栏目ID/专题ID,显示条数,操作类型,只显示有标题图片}]$user=$empirefetch1("select company from phome_enewsmemberadd where userid='$bqr[userid]' limit 1");=$user[company][/e:loop]