Sort by SUM value?

[Stuve]

Why can't I order by SUM value? I get this error "Invalid use of group function".

 

$sql="SELECT *, SUM(sm), SUM(gm), SUM(a), SUM(tp), SUM(um)

        FROM spelarstat

        WHERE lagid = '".$_GET['id']."'

        GROUP BY spelarid

        ORDER BY SUM(tp) DESC, SUM(gm) DESC, SUM(a) DESC, SUM(um)";

 

Help me please!!

[kenrbnsn]

Try giving each SUM a name:

<?php
$sql="SELECT *, SUM(sm) as sum_sm, SUM(gm) as sum_gm, SUM(a) as sum_a, SUM(tp) as sum_tp, SUM(um) as sum_um
        FROM spelarstat
        WHERE lagid = '".$_GET['id']."'
        GROUP BY spelarid
        ORDER BY sum_tp DESC, sum_gm DESC, sum_a DESC, sum_um";
?>

 

Ken

[SammyGunnz]

 

 

.

[Stuve]

Thanx a lot! 

[Stuve]

Btw.. is it possible to get the MAX value from a SUM value?

Something like this:

 

SELECT MAX(SUM(a)) FROM stat GROUP BY id

[teng84]

Btw.. is it possible to get the MAX value from a SUM value?

Something like this:

 

SELECT MAX(SUM(a)) FROM stat GROUP BY id

before asking like this you should try it first  ???  any way it will work

[Stuve]

No, it's not working.. I get "Invalid use of group function"...