php - 如何按变量排序？

Question

我不知道为什么它不起作用...我正在尝试“排序”创建的变量，如下所示:

mysql_query("SELECT *,DATE_FORMAT(FROM_UNIXTIME(banfrom), '%d/%m/%Y') as time FROM ab_list WHERE time = '24/08/2013' ORDER BY banfrom DESC LIMIT 0,50");

或者，

   $hr = date('d/m/Y');
   mysql_query("SELECT *,DATE_FORMAT(FROM_UNIXTIME(banfrom), '%d/%m/%Y') as time FROM       ab_list WHERE time = '$hr' ORDER BY banfrom DESC LIMIT 0,50");

Answer 1

假设变量$hr的格式为%d/%m/%Y，您可以使用having代替 >where 过滤记录。

mysql_query("SELECT *,DATE_FORMAT(FROM_UNIXTIME(banfrom), '%d/%m/%Y') as time 
             FROM ab_list 
             HAVING time = '$hr' 
             ORDER BY banfrom DESC 
             LIMIT 0,50");

在这种情况下使用 HAVING 而不是 WHERE 的原因是因为 time 是计算列。