I am working on a Hockey Pool stat project. My PPG column is a calculation that divides PTS by GP. This works fine for anyone that has played a game. However, in the case of Rookies or the very beginning of the season the GP number is 0. As such, when it is "0" it returns a DIVISION BY ZERO error. Instead of this error, I would like to simply return the result to be "0.00". I have not had any success finding a solution. Hoping someone can help!

Here is the code that I have been using for this column of my query output.

echo number_format($row['PTS0910']/$row['GP0910'],2);

thanks in advance everyone!

6 Years
Discussion Span
Last Post by ceeandcee

The division by zero error is only a warning so it doesn't stop execution. You can prevent the warning from printing (if necessary) using error_reporting (E_ERROR);

It looks as if the division by zero returns false rather than a numeric value. Thus, your code could be changed as follows:

$result = $row['PTS0910']/$row['GP0910'];
if ($result == false) {
   $result = 0.00;

echo  number_format($result,2);

Thank you so much. this is exactly what I was looking for. The error_reporting (E_ERROR); was the answer!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.