多表指定多栏目信息调用
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
更多精彩
赞助商链接