hello
i was wondering if anybody could shed some light for me on the fact as to why i keep getting the following error code all throughout my page..
i know its on about the mysrl_real_escape_string but i dont understand what is wrong with the code.. everything its asking the database for exists but for some reason it wont work.
<?php
// dit stuk script moet straks voor het tonen per league. schrijft de fixtures (gespeelde wedstrijden) naar de competition tabel
// dit is de quert om de competitie tabel qua scores leeg te maken
$empty_sql = "UPDATE competition, league ".
"SET competition.won = '0', competition.draw = '0', competition.lost = '0', competition.for = '0', competition.against = '0' ".
"WHERE competition.league_id = league.league_id ".
"AND league.league_name = '" . mysql_real_escape_string ($league) . "' ";
//echo "$empty_sql<br>";
mysql_query($empty_sql);
// deze query haalt de fixtures van 1 league en 1 jaar op , vervolgens zullen deze doorlopen worden en in de competition tabel weggeschreven worden;
$sql = "SELECT league.league_name, fixtures_result.hometeam_id, fixtures_result.awayteam_id, ".
"fixtures_result.home_result, fixtures_result.away_result, fixtures_result.fixture_ignore FROM ".
"fixtures_result ".
"INNER JOIN league ON (fixtures_result.league_id = league.league_id) WHERE ".
"(league.league_name = '" . mysql_real_escape_string($league) . "') ";
//echo $sql;
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
// nog controleren op leeg en of 0 ook zo wordt opgevat
if (is_numeric($row[3]) and is_numeric($row[4]) AND $row[5]=="no"){
//opbouwen dynamische update query voor home team
$sql_update_home = "UPDATE competition, league SET ";
if ($row[3] > $row[4]){
$sql_update_home .= " competition.won = competition.won + 1, ";
}elseif ($row[3] < $row[4]){
$sql_update_home .= " competition.lost = competition.lost + 1, ";
}elseif ($row[3] == $row[4]){
$sql_update_home .= " competition.draw = competition.draw + 1, ";
}
$sql_update_home .= "competition.for = competition.for + $row[3], ".
"competition.against = competition.against + $row[4] ".
"WHERE competition.team_id = $row[1] ".
"AND competition.league_id = league.league_id ".
"AND league.league_name = '$league' ";
mysql_query($sql_update_home);
//opbouwen dynamische update query voor away team
$sql_update_away = "UPDATE competition, league SET ";
if ($row[3] < $row[4]){
$sql_update_away .= " competition.won = competition.won + 1, ";
}elseif ($row[3] > $row[4]){
$sql_update_away .= " competition.lost = competition.lost + 1, ";
}elseif ($row[3] == $row[4]){
$sql_update_away .= " competition.draw = competition.draw + 1, ";
}
$sql_update_away .= "competition.for = competition.for + $row[4], ".
"competition.against = competition.against + $row[3] ".
"WHERE competition.team_id = $row[2] ".
"AND competition.league_id = league.league_id ".
"AND league.league_name = '$league' ";
//echo "<br>away: $sql_update_away<br>";
mysql_query($sql_update_away);
// voor als een wedstrijd abandoned is dan moet iedereen verliezen
}elseif ($row[5]=="yes"){
$sql_abandoned_home = "UPDATE competition, league SET competition.lost = competition.lost + 1 ".
"WHERE competition.team_id = $row[1] AND competition.league_id = league.league_id ".
"AND league.league_name = '" . mysql_real_escape_string($league) . "' ";
mysql_query($sql_abandoned_home);
$sql_abandoned_away = "UPDATE competition, league SET competition.lost = competition.lost + 1 ".
"WHERE competition.team_id = $row[2] AND competition.league_id = league.league_id ".
"AND league.league_name = '" . mysql_real_escape_string($league) . "' ";
mysql_query($sql_abandoned_away);
}
}
?>
does anybody have any suggestions to sorting this issue out please?
cheers in advance 
