Why Do i Get This Error With This Code:

Error:

PHP Code:

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/champion/public_html/functions/tables.php on line 7 


Code:

PHP Code:

<?php 
include("**");
// Update League Table After Games
$league = "Premiership";
                    mysql_query("DELETE FROM `manager__tables` WHERE `league` = '$league'");
                    $sql = mysql_query("SELECT * FROM `manager__teams` WHERE `league` = '$league'");
            while($row = mysql_fetch_array($sql))
            {
             $played = mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "' || `away_team` = '" . $row['id'] . "'"));
             // Wins
             $win = mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "' && `home_points` = '3'"));
             $win = $win + mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `away_team` = '" . $row['id'] . "' && `away_points` = '3'"));
             // Draw
             $draw = mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "' && `home_points` = '1'"));
             $draw = $draw + mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `away_team` = '" . $row['id'] . "' && `away_points` = '1'"));
             // Lose
             $lose = mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "' && `home_points` = '0'"));
             $lose = $lose + mysql_num_rows(mysql_query("SELECT * FROM `manager__games` WHERE `away_team` = '" . $row['id'] . "' && `away_points` = '0'"));
             // Goals For
             $sql = mysql_fetch_array(mysql_query("SELECT SUM(home_score) FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "'"));
             $sql2 =  mysql_fetch_array(mysql_query("SELECT SUM(away_score) FROM `manager__games` WHERE `away_team` = '" . $row['id'] . "'"));
             $for = $sql['SUM(home_score)'] + $sql2['SUM(away_score)'];
             // Goals Against
             $sql = mysql_fetch_array(mysql_query("SELECT SUM(away_score) FROM `manager__games` WHERE `home_team` = '" . $row['id'] . "'"));
             $sql2 =  mysql_fetch_array(mysql_query("SELECT SUM(home_score) FROM `manager__games` WHERE `away_team` = '" . $row['id'] . "'"));
             $against = $sql['SUM(away_score)'] + $sql2['SUM(home_score)'];
             // Goal Difference
             $goal_difference = $for - $against;
             // Total Points
             $points = ($win * 3) + ($draw * 1);
             // Truncate & New League Stats
             mysql_query("INSERT INTO `manager__tables` ( `team_id` , `played`, `win`, `draw` , `lose, `goals_for`, `goals_against`, `goal_difference`, `points`, `league` ) VALUES ('" . $row['id'] . "', '$played', '$win', '$draw', '$lose', '$for', '$against', '$goal_difference', '$points', '$league')");
             }
                    ?>

Found out why i had $sql in my while so it buggered up!

I think a good feature could be the ability to delete your own threads, as long as no one else has replied and its within a certain time scale

Lol im always doing this and right after i post it a realise the problem! LOL