PHP MySQL返回分割结果

Question

我有疑问:

SELECT * FROM members ORDER BY ( firstColumn / anotherColumn ) DESC

现在我打印这个:

return $query['firstColumn'] / $query['anotherColumn'];

是否可以在没有任何 php 技巧的情况下打印分割结果？例如 return $query['dividedColumns'];

Answer 1

列别名将解决您的问题，您可以将查询更改为:

SELECT members.*, 
      ( firstColumn / anotherColumn ) AS `divided_amount`  
FROM members 
ORDER BY divived_amount DESC;