Sign in to follow this  
Followers 0
Swift-R

Calculate win/loss ratio, how?

10 posts in this topic

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

<?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

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

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

Yes I got it, thanks ;D

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

Share this post


Link to post
Share on other sites

soooo... did it work? :D

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

Share this post


Link to post
Share on other sites

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

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

Share this post


Link to post
Share on other sites
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
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.