Somewhat a project here
Posted: Wed Feb 04, 2004 3:31 pm
Okay I'm building a gaming website and I'm planning on making a little script that has the records. The admin enters the records with a form that looks like this
Opponent:
Map:
Date:
Win/loss/tie:
Scrim/Cal:
I know how to enter this all into a database and everything blah blah but my problem is this.
In my main page http://www.jcartonline.com/xe/ You will see A little Records part that looks like this
Cal - 100-0-0 - .999 - info
Scrim - 100-0-0 - .999 - info
What I can't really figure out is how I'm going to calculate the totals wins and losses for each different one. I'm thinking maybe I should have 2 different tables to seperate them... another problem is how am I going to get the decimal. For those of you who are unware .500 is 1-1 ratio and 1.0 is 1-0 ... so 2-1 would be like .750
Opponent:
Map:
Date:
Win/loss/tie:
Scrim/Cal:
I know how to enter this all into a database and everything blah blah but my problem is this.
In my main page http://www.jcartonline.com/xe/ You will see A little Records part that looks like this
Cal - 100-0-0 - .999 - info
Scrim - 100-0-0 - .999 - info
What I can't really figure out is how I'm going to calculate the totals wins and losses for each different one. I'm thinking maybe I should have 2 different tables to seperate them... another problem is how am I going to get the decimal. For those of you who are unware .500 is 1-1 ratio and 1.0 is 1-0 ... so 2-1 would be like .750