The Kamael SQL COUNt in existing command

[robikbobik]

Hi,

I want to count all points from table character_raid_points for same charId

Example: I have 100 records for charID: 11111 and in every records has different int points for kill RB.


So I need to COUNT all RBs points per charId

Code: [Select]

"SELECT characters.char_name,character_raid_points.charId, character_raid_points.points FROM character_raid_points, characters WHERE character_raid_points.points AND characters.charId = character_raid_points.charId ORDER BY points DESC LIMIT 10;"
This command now generate CharId and points pet one row ( i mean per one kill RB )  - so Need to count all to one INT