SQL Query Request (Frags)

[sobek07]

I was trying to make a SQL Query ( use the existing one of Elf )

$frag = $SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags`
	FROM `killers` k
	LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
	LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
WHERE `k`.`unjustified` = 1
	GROUP BY `name`
	ORDER BY `frags` DESC, `name` ASC
	LIMIT 0,1;') as $player)
	
foreach($frag as $player){

echo 'Frags: ' . $player['frags'] . ' ';
}

But as it seems to be its wrong and have no idea how to fix.. What i want? :] i want add it in a new <tr> in characters.php


Thanks!

 

[sobek07]

Bring
It
Down :]