Adding all the results from all the fields.

[u214]

Hello guys. Let's say I have my DB set up as: "SELECT * FROM playerinfo WHERE kills > 0"

 

Playerinfo has information about players, each player has kills. How to add up ALL the kills FROM ALL players?

 

Thanks.

[HDFilmMaker2112]

Try adding SUM(kills) to the SQL query.

[mikesta707]

What you are looking for is the SUM mysql function. For example

 

$res = mysql_query("SELECT SUM(kills) as num_kills FROM playerinfo WHERE kills > 0");
$row = mysql_fetch_array($res);
echo "There are : ". $row['num_kills']." total kills";

 

EDIT: bah sniped, but ill post anyways, as I have an example

[u214]

Hello. Thanks for the feedback.

 

I try doing it this way:

$total_kills = mysql_query("SELECT SUM(kills) FROM playerinfo", $connect);
echo $total_kills;

 

That outputs: "Resource id #5"

[revraz]

That's because it's a resource and not the result.  Use the examples that were provided.

[HDFilmMaker2112]

Hello. Thanks for the feedback.

 

I try doing it this way:

$total_kills = mysql_query("SELECT SUM(kills) FROM playerinfo", $connect);
echo $total_kills;

 

That outputs: "Resource id #5"

 

mysql_query only gives you the id location in the database. You have to apply that to an array to actually pull data out of it. Use:

 

$total_kills=mysql_fetch_array($total_kills)

 

directly after

$total_kills = mysql_query("SELECT SUM(kills) FROM playerinfo", $connect);

[u214]

Thank you so much.