$jjzx = get("SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 902 AND 910) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8");
$zxfs = get("SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 923 AND 927) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8");
$jcjj = get("SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 912 AND 921) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8");
$zxgl = get("SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 939 AND 940) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8");要能实现每一个现有的语句都要读取八条数据 求解
((`catid` BETWEEN 902 AND 910)
or
(`catid` BETWEEN 923 AND 927)
or
(`catid` BETWEEN 912 AND 921)
or
(`catid` BETWEEN 939 AND 940))
AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8;
也可以将OR->UNION ALL
SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 902 AND 910) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8
UNION
SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 923 AND 927) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8
UNION
SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 912 AND 921) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8
UNION
SELECT `url`,`thumb`,`title`,`inputtime` FROM `phpcms_content` WHERE (`catid` BETWEEN 939 AND 940) AND `status`=99 AND `thumb`!='' ORDER BY `inputtime` DESC LIMIT 8用union试下