No logro sumar columnas de MySQL y mostrarlas ordenadas en php

[quimfv]

Código MySQL:

SELECT name, SUM(puntos) as TPuntos,
SUM(p_g) as Tp_g, SUM(p_e) as Tp_e, SUM(p_p) as Tp_p, SUM(g_f) as Tg_f, SUM(g_c) as Tg_c, SUM(pj) as Tpj, SUM(descuento) as Tdescuento 
FROM equipos 
WHERE id_cat IN ('04','05') AND id_div = 'A' 
GROUP BY name 
ORDER BY SUM(puntos) DESC;
 

Y asi funciona!!!!

Lee el manual sobre GROUP BY!!!!

Código MySQL:

SELECT id_div,name, SUM(puntos) as TPuntos,
SUM(p_g) as Tp_g, SUM(p_e) as Tp_e, SUM(p_p) as Tp_p, SUM(g_f) as Tg_f, SUM(g_c) as Tg_c, SUM(pj) as Tpj, SUM(descuento) as Tdescuento 
FROM equipos 
WHERE id_cat IN ('04','05')
GROUP BY id_div,name 
ORDER BY id_div,TPuntos DESC;