PHP Code:

$sql2 = mysql_fetch_array(mysql_query("SELECT manager__playing.player_id, manager__playing.team_id, manager__playing.status, SUM(manager__players.rating) AS rating FROM manager__playing LEFT JOIN manager__players ON manager__playing.player_id = manager__players.player_id WHERE manager__playing.current_position >= '1' && manager__playing.current_position <= '" . ($away_formation['defender'] + 1) . "' && manager__playing.status != '4' && manager__playing.match_id = '" . $match_id . "' && manager__playing.team_id = '" . $away_team . "'")); 


I want to return the sum of the manager__players.rating, however when i use the SUM(manager__players.rating) i get this error:

PHP Code:

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/championshipfl/**/**/match/match2.php on line 199 


Anyone no why?

Originally Posted by evans123

PHP Code:

$sql2 = mysql_fetch_array(mysql_query("SELECT manager__playing.player_id, manager__playing.team_id, manager__playing.status, SUM(manager__players.rating) AS rating FROM manager__playing LEFT JOIN manager__players ON manager__playing.player_id = manager__players.player_id WHERE manager__playing.current_position >= '1' && manager__playing.current_position <= '" . ($away_formation['defender'] + 1) . "' && manager__playing.status != '4' && manager__playing.match_id = '" . $match_id . "' && manager__playing.team_id = '" . $away_team . "'")); 


I want to return the sum of the manager__players.rating, however when i use the SUM(manager__players.rating) i get this error:

PHP Code:

Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/championshipfl/**/**/match/match2.php on line 199 


Anyone no why?

From my experience you need to use a "GROUP BY" clause to use the SUM() function. At the end of your query try adding;

GROUP BY manager__players.player_id

This will return the SUM of the rating for each player (one would hope anyway)

Maybe the query doesn't do exactly what you intended, but there doesn't seem to be any errors in it. Since the error message says it is the argument being passed to mysql_fetch_array() that is invalid, that is, the result from mysql_query(). The mysql_query() function itself seem to be executed properly. Perhaps no rows are returned?