[SOLVED] query help

[Minase]

hmm how i can make this query to make the sum of capture?? i dont have too much time and i need to fix it quick

 

$ranking = mysql_query("SELECT * FROM `" . DBPREFIX . "users` WHERE ClanID != '0' GROUP BY `ClanID` ORDER BY Capture DESC Limit $limit") or die(mysql_error());

 

the above query works well but i want it to order by capture SUM thx

[budimir]

$ranking = mysql_query("SELECT * FROM `" . DBPREFIX . "users` SUM(capture) as capture WHERE ClanID != '0' GROUP BY `ClanID` ORDER BY Capture DESC Limit $limit") or die(mysql_error());

[Minase]

// edit

 

solved with

SELECT *, SUM(Capture) s Capture FROM 

 

never though that *, SUM(Capture) will work