WEB开发网
开发学院CMS教程帝国CMS 多表指定多栏目信息调用 阅读

多表指定多栏目信息调用

 2012-03-30 10:29:24 来源:WEB开发网   
核心提示: 代码如下:[ecmsinfo]'select * from (select * from phome_ecms_表名1 where checked=1 and classid in (1610,1616) union select * from phome_ecms_表名2 where checked=1

  代码如下:
----------------------------------------------------------------
[ecmsinfo]'select * from (select * from phome_ecms_表名1 where checked=1 and classid in (1610,1616) union select * from phome_ecms_表名2 where checked=1 and classid in (1289,1290,1291)) a order by newstime desc limit 100',100,40,1,24,54

1 2  下一页

Tags:指定 栏目 信息

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接