[Resolved] [Resolved] Adding all values from selected rows

[ExpendableDecoy]

Hi there,

SELECT total_wins FROM test_characters
WHERE character_id = $user_id

I'm currently trying to make a query that will select the total_wins column then search all rows that equal the character_id and then add all the values of the given rows together.

Could someone advise me the best way to do this?.

Thanks. 🙂

[Pig]

SELECT SUM(total_wins) FROM test_characters WHERE character_id = $user_id

[ExpendableDecoy]

Thank you. 🙂

[ExpendableDecoy]

Actually, how would you correctly return the result of that query as well?.

[Pig]

$sql = "SELECT SUM(total_wins) FROM test_characters WHERE character_id = $user_id"
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$total = $row[0];