Storing the number of wins, draws and losses, points for and points against, in the database would be enough. Then in the reporting, the Points column would be calculated as:
You could even do all that in your MySQL query. What is your table structure?
Thanks - that makes sense:
Here's my table structure:
How does that work combining the SQL with the php that calls in the data then?
Also when I enter 'Team A' in my textbox, how will php say. Right I want to see all the 'Team A' records in the database and add up their goal difference?
Thanks
Chris
Your MySQL query for the league table would then be:
The "played", "gd" and "points" columns are redundant. I would leave them out - they only add to your work and could lead to inconsistencies if something went wrong.
Plus, you should always add a Primary Key (called ID or similar) to your table - even if you don't think you will need one.
As I see it, you won't be storing the results of each game independently - just the league table?
Your UPDATE query for inserting the data will be simple enough, just need to confirm how you are doing this. You wouldn't even need the league_table table if you stored all the individual games. Just a teams table with the names.
Deleted as I kindof understand now - please see below thanks
Or maybe something like this, but I can't get it to save to the database!
include("check.php");
include("common.php");
if (isset($_POST['Submit']) && $_POST['Submit'] == 'Submit'){
//Begin processing
//Update the scores for the first team in the first game
$query = "UPDATE league_table SET
gf = gf + '{$_POST['match1Score1']}',
ga = ga + '{$_POST['match1Score2']}'
WHERE team = '{$_POST['match1Team1']}'";
//Update the scores for the second team in the first game
$query = "UPDATE league_table SET
gf = gf + '{$_POST['match1Score2']}',
ga = ga + '{$_POST['match1Score1']}'
WHERE team = '{$_POST['match1Team2']}'";
if($query){
echo 'Football scores and tables have all been entered successfully.';
}
elseif(!$query){
echo 'There was a problem updating the leage table.';
}
} // End processing
?><html>
<head>
<title>Table</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="">
<table width="100%" border="0">
<tr bgcolor="#FFFF00">
<td colspan="5">Match One:</td>
</tr>
<tr>
<td>
<div align="center">Team One</div>
</td>
<td>
<div align="center">Team One Goals Scored</div>
</td>
<td rowspan="2" bgcolor="#CCCCCC"> </td>
<td>
<div align="center">Team Two</div>
</td>
<td>
<div align="center">Team Two Goals Scored</div>
</td>
</tr>
<tr>
<td>
<div align="center">
<input type="text" name="match1Team1">
</div>
</td>
<td>
<div align="center">
<input type="text" name="match1Score1">
</div>
</td>
<td>
<div align="center">
<input type="text" name="match1Score 2">
</div>
</td>
<td>
<div align="center">
<input type="text" name="match1Score 2">
</div>
</td>
</tr>
</table>
<p>
<input type="submit" name="Submit" value="Submit" class="button">
<input type="reset" name="Reset" value="Reset" class="button">
</p>
</form>
</body>
</html>
<?php
}
?>
You need to execute the UPDATE queries - using the mysql_query() function in PHP.
Hi Guys,
I'm trying to create a league table system for my football content managed system:
So I have my league table:
I want to then create an admin screen which I can enter the results in:
and then when I hit submit the table is updated accordingly.
I have not got the feintest where to start and to create rules such as +3 points for every win, add 2 goals every goal conceded -1 etc. Can anyone point me in the right direction?
Thanks
Chris