Problem with SUM()

Grr, why is this not working:

$query = mysql_query("SELECT *,SUM(hot-nothot) AS lol FROM chart WHERE active='Y' GROUP BY lol LIMIT 10") or die("Unable to complete query");

I try "hot minus nothot". example 5-2 and then group (or maybe order?) it by the result: 3

Is this possible?

I don't think it's possible because it can't group by the result of it: 3. Pretty obvious.

I try an other way. 🙂

Are you sure group by is what you need?

It looks like something more like this might work:

select id, (hot-nothot) as lol from table order by lol desc;

Yes, i was looking for something like that.

It works perfect, thanks for the help.

you're welcome!