Hello i would like to have som help with an sql command.
This is my table :
Code:
id int(10) NO PRI NULL auto_increment
steamid_killer varchar(20) YES NULL
steamid_victim varchar(20) YES NULL
weapon varchar(15) YES NULL
headshot varchar(1) YES NULL
killtime datetime YES NULL
And as you see it ill be one line for each kill.
I would like an sql that reads out a list/array with how many kills, deaths and suisude every person have in the past week.
is it possible to make that in one sql command or do i have to make an sql for each value and player.
The thing is that if i have to make it with one sql/player then it would be 90 sql commands each visit and im guesing thats not so fun for the server
BR. Jonas