Archived

This topic is now archived and is closed to further replies.

Calculate win/loss ratio, how?

Recommended Posts

Swift-R    2

Hello,

I've never calculated ratios before in php and I can't find how to.

I'm trying to calculate the win/loss ratio for my clan matches.

How can I do this?

MySQL table name: egr_matches
important fields: opponent, ourscore, theirscore

Thank you,

Swift-R.

Share this post


Link to post
Share on other sites
abshack    0

<?php

$host = "your_host_address_or_ip"; //often localhost
$user = "username";
$password = "password";

$mydb = "your_database_name";
mysql_connect($host, $user, $password) or die(mysql_error());
mysql_select_db($mydb) or die(mysql_error());

$sQuery = mysql_query("SELECT ourscore as A, theirscore as B, opponent as C FROM egr_matches");
$wins = 0;
$games = 0;
while($row = mysql_fetch_array($sQuery)){
	 if($row['A'] > $row['B']) {$wins = $wins + 1;}
	 $games = $games + 1;
}

$wlRatio = $wins / $games;

echo "Our win ratio was ".$wlRatio.".";

?>

Written using copy-paste from tutorials... :\

Share this post


Link to post
Share on other sites
Swift-R    2

Is ratio supposed to be a percentage? Because it results numbers like 0.682823... I have like a 6:3 ratio.

Share this post


Link to post
Share on other sites
Rudy    457

you calculate it like this:

games won / games played

you'll get something like 0.xx and you can get the percentage by * 100

Share this post


Link to post
Share on other sites
Swift-R    2

Yes I got it, thanks ;D

$winsratio = round(($wins / $games) * 100, 0);

Share this post


Link to post
Share on other sites
abshack    0

soooo... did it work? :D

that was totally googled & not tested code, btw.. :)

Share this post


Link to post
Share on other sites
Swift-R    2

Yes it worked perfectly, click in my signature' banner and check Matches page if you want to see it working.

However, I've multiplied it to 10 instead of 100 to give a ratio like 7:3 instead of 73:32. :)

Thank you very much.

Share this post


Link to post
Share on other sites
abshack    0

yay... always glad my Googling was of use.. :)

Share this post


Link to post
Share on other sites
+LogicalApex    1,745
Yes I got it, thanks ;D

$winsratio = round(($wins / $games) * 100, 0);

Yes it worked perfectly, click in my signature' banner and check Matches page if you want to see it working.

However, I've multiplied it to 10 instead of 100 to give a ratio like 7:3 instead of 73:32. :)

Thank you very much.

I'm not sure your ratio code is accurate or maybe you're just not simplifying your fraction?

If you're going to display a ratio as 1:2 that would be equal to 1/2 so you wouldn't need to do any math on it like your doing unless to simplify the fraction to its lowest terms...

Share this post


Link to post
Share on other sites
Swift-R    2
I'm not sure your ratio code is accurate or maybe you're just not simplifying your fraction?

If you're going to display a ratio as 1:2 that would be equal to 1/2 so you wouldn't need to do any math on it like your doing unless to simplify the fraction to its lowest terms...

$ = ROUND(x, 0)

1:2 means we won 1 match in every two matches.

;)

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.