What is wrong with this sum query?

[t_machine]

hi, I can't seem to figure out why the query is failing. I run it on my local host and it works but when placed online it fails.

$wpoints = query_db("select u_id, SUM(points) from table where b_id='2' group by u_id order by SUM(points)");

When I try to get a numrows it shows blank online but on local host it shows the correct amount.

The table contains u_id, points and b_id
The b_id is a category id, u_id is the user and then points.
The u_id is entered a number of times in the table with points. I would like to sum the points for each u_id and order them by the ones with the most points.

Any help would be greatly appreciated :)

[obsidian]

Try naming your aggregate and ordering by that name:
[code]
SELECT u_id, SUM(points) AS points FROM table WHERE b_id = '2' GROUP BY u_id ORDER BY points;
[/code]

[t_machine]

Thank you very much :) Works perfectly now.