warning: division by zero

[msnhockey]

hey all,

I know this warning is from an empty database, but wondering if there is a way to paypass it.. here is the code that is giving me the problem

$p_array[$playerid][shoot] = ROUND($p_array[$playerid][goals] / $p_array[$playerid][xtra4] * 100, 2);

is there a way to continue using this code and also get it to use this code if the above can't be executed
$p_array[$playerid][shoot] = '0'

below is a more indepth code

while ($row = mysql_fetch_assoc($result_stats)) 
    {

//start point stats



            $sc = 0;

			$p_array = Array();

			while($sc < $statcount) {

$playerid = mysql_result($result_stats,$sc,"players.id");

$p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"player_stats.goals");

$p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$sc,"player_stats.assists");

$p_array[$playerid][pts] = $p_array[$playerid][pts] + mysql_result($result_stats,$sc,"player_stats.goals") + mysql_result($result_stats,$sc,"player_stats.assists");

$p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$sc,"player_stats.minutes");

$p_array[$playerid][xtra1] = $p_array[$playerid][xtra1] + mysql_result($result_stats,$sc,"player_stats.xtra1");

$p_array[$playerid][xtra2] = $p_array[$playerid][xtra2] + mysql_result($result_stats,$sc,"player_stats.xtra2");

$p_array[$playerid][xtra3] = $p_array[$playerid][xtra3] + mysql_result($result_stats,$sc,"player_stats.xtra3");

$p_array[$playerid][xtra4] = $p_array[$playerid][xtra4] + mysql_result($result_stats,$sc,"player_stats.xtra4");

$p_array[$playerid][xtra5] = $p_array[$playerid][xtra5] + mysql_result($result_stats,$sc,"player_stats.xtra5");

$p_array[$playerid][gminutes] = $p_array[$playerid][gminutes] + mysql_result($result_stats,$sc,"player_stats.gminutes");


$p_array[$playerid][shoot] = ROUND($p_array[$playerid][goals] / $p_array[$playerid][xtra4] * 100, 2);






$p_array[$playerid][position] = mysql_result($result_stats,$sc,"players.position");
$p_array[$playerid][fname] = mysql_result($result_stats,$sc,"players.fname");
$p_array[$playerid][lname] = mysql_result($result_stats,$sc,"players.lname");
$p_array[$playerid][status] = mysql_result($result_stats,$sc,"players.status");
$p_array[$playerid][injurystatus] = mysql_result($result_stats,$sc,"players.injurystatus");
$p_array[$playerid][team] = mysql_result($result_stats,$sc,"teams.name");
$p_array[$playerid][teama] = mysql_result($result_stats,$sc,"teams.teama");

//Added next 3 lines for showing links for players and teams 10-14-05 DJ

$p_array[$playerid][tid] = mysql_result($result_stats,$sc,"teams.id");
$p_array[$playerid][divid] = mysql_result($result_stats,$sc,"teams.division");
$p_array[$playerid][pid] = mysql_result($result_stats,$sc,"players.id");$sc++;

			}

[laserlight]

Check for the condition, i.e., check that $p_array[$playerid][xtra4] != 0.

Incidentally, those indices are probably string literals rather than defined constants, so you should write $p_array[$playerid]['xtra4'] instead.

[msnhockey]

tried your example, but stays the same. then tried doing with all and nothing..

[laserlight]

What did you try?

Oh yes, and please set error_reporting to E_ALL during development.