[SOLVED] MySQL or php?
Moderator: General Moderators
[SOLVED] MySQL or php?
I am querying a table for the sums of a couple rows - and so I used SUM(`xxxxx`) AS `sumx`, SUM(`yyyyyy`) AS `sumy` But then i want to sort them by the division of sumy into sumx, so i figured i could do `sumx` / `sumy` = `per` then order by `per` DESC at the end. However, I am getting an error that says that `sumx` and `sumy` dont exist. What to do?
Last edited by Todd_Z on Fri Oct 07, 2005 2:20 pm, edited 2 times in total.