COUNT Problem.

Mark_Nordstrom

Ok Whats wrong with this code ?

SELECT 100*COUNT(winner)/COUNT(loser)
FROM games
WHERE winner='nj' and loser='nj'
GROUP BY winner

I need to count the percent of the teams record say they got 1 win and 1 loss there record is .500 but it does not work.

Weedpacket

It will only look for games where both the winner AND loser were 'nj'! That's the biggy; there are other bugs.

It might be easier to do this in PHP.
SELECT COUNT(*) as wins FROM games WHERE winner='nj'

SELECT COUNT(*) as losses FROM games WHERE loser='nj'

Do those queries, get the $wins and $losses from the rows returned, and then

if($losses==0 && $wins==0) $percentage=0;
elseif($losses==0) $percentage=100;
else $percentage=100*$wins/$losses;

Xzone5

I imagine that this outputs 100, due to the order of operations. Try:

$query = "SELECT (100*(COUNT(winner))/(COUNT(loser)))
                 FROM games
                 WHERE (winner or loser) = nj
                 GROUP BY winner";

Mark_Nordstrom

What would be the fully query to display it in a table ?

Xzone5

$query = "SELECT (100*(COUNT(winner))/(COUNT(loser)))
$result = mysql_query($query);
echo $result;