Getting count of something in table.

[Faraonekkk]

I wanna count something in table killscount:

I wannna sum up it 3+1+x+x+x (plus everything what is in table killscount)

can anyone help me?

 

[Summ]

SELECT SUM(`level`) as totalLevel FROM `players`
-> Example on total level

SELECT SUM(`killscount`) FROM `player_kills`
-> Yours should be like that, adjust the table.

 

[Faraonekkk]

SELECT SUM(`level`) as totalLevel FROM `players`
-> Example on total level

SELECT SUM(`killscount`) FROM `player_kills`
-> Yours should be like that, adjust the table.

Then to get result
$opgnnadf = $row27['killscount'];

??
/\
nnot work xD

 

[Summ]

Post query.

 

[Faraonekkk]

$irutqwers = mysql_query("SELECT SUM(`killscount`) FROM `players` WHERE nationallity = '$qretbarqe'");

here summ bro, like a fish "sum" xD

 

[Summ]

$irutqwers = mysql_query("SELECT SUM(`killscount`) as killscount FROM `players` WHERE nationallity = '$qretbarqe'");
Try that.

 

[Faraonekkk]

good job 6+!!

working perfectly