Code: Select all
<?php
$con = mysql_connect ('localhost', '******', '******');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("roondog_news", $con);
$ht1 = $_POST['hometeam1'];
$at1 = $_POST['awayteam1'];
$ht1s = $_POST['hometeam1_score'];
$at1s = $_POST['awayteam1_score'];
if (isset($ht1s)) {
mysql_query("UPDATE league SET played = played +1
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET played = played +1
WHERE teamname = '$at1'");
if ($ht1s > $at1s) {
mysql_query("UPDATE league SET won = won +1
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET lost = lost + 1
WHERE teamname = '$at1'");
mysql_query("UPDATE league SET points = points + 3
WHERE teamname = '$ht1'");
}else if ($ht1s < $at1s) {
mysql_query("UPDATE league SET lost = lost +1
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET won = won +1
WHERE teamname = '$at1'");
mysql_query("UPDATE league SET points = points + 3
WHERE teamname = '$at1'");
}else{
mysql_query("UPDATE league SET drawn = drawn +1
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET drawn = drawn +1
WHERE teamname = '$at1'");
mysql_query("UPDATE league SET points = points +1
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET points = points +1
WHERE teamname = '$at1'");
}
/*from here to the end the table isn't updating
*/
{
mysql_query("UPDATE league SET for = for +$ht1s
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET away = away +$at1s
WHERE teamname = '$ht1'");
mysql_query("UPDATE league SET for = for +$at1s
WHERE teamname = '$at1'");
mysql_query("UPDATE league SET away = away +$ht1s
WHERE teamname = '$at1'");
}
}
{
mysql_query("UPDATE league SET goaldif = for - away");
}
mysql_close($con);
?>