$New_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=1 ORDER BY amount DESC");
$Old_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=0 ORDER BY linktime DESC");
现在用这两条查询.查出来的结果分页处理不方便.可否实现一条语句就完成?这个查询语句如何写?
...全文
408打赏收藏
这个查询语句如何写?
$New_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=1 ORDER BY amount DESC"); $Old_Link = mysql_query("SELECT * FROM ads_link WHERE linkactive=0 ORDER BY linktime DESC"); 现在用这两条查询.查出来的结果分页处理不方便.可否实现一条语句就完成?这个查询语句如何写?