列表内容模板(list.var)代码:$uid=$empirefetch1(select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]});$usql=$empirefetch1(select * from {$dbtbpre}enewsmember where userid = {$r[userid]});$use
新增自定义列表页:查询SQL语句:统计记录:select count(*) as total from [!db.pre!]enewsmember查询记录:select u.*,ui.* from [!db.pre!]enewsmember u LEFT JOIN [!db.pre!]enewsmemberadd ui ON u.userid=ui.useri
为大家介绍下帝国cms会员发布相关信息列表的调用方法以下是调用标签代码$sql=$empirequery(select * fromphome_ecms_recruitment where userid=$navinfor[userid] and clasid=29 order by newstime asc limit 100);w