Hi,

I am getting division by zero error in php.....please help.

Here's the code.

PHP Code:

$biz_val= $row_c['biz_id'];
                        $sql_rat="select * from tblrating where rat_biz_id = ".$row_c['biz_id']."";
                        $result_rat = mysql_query($sql_rat);
                        $tot_rec = mysql_fetch_array($result_rat);
                        $i=$j=$d=0;
                        //$row_rt = 0;
                    if($tot_rec>0)
                    {        $row_rt = $tot_rec;
                        while ($i=mysql_fetch_array($result_rat))
                        {
                            $i++;
                            $j= $row_rt['rat_num'] + $j;
                        }    
                        $d=$j/$i;
                      if ($d<=1.50)
{
echo img1.gif;
}
if ($d<=2.50 && $d>=1.51)
{
echo img2.gif;
}
}
else
{
echo img0.gif;
} 


The problem is here:

PHP Code:

                        while ($i=mysql_fetch_array($result_rat))
                        {
                            $i++;
                            $j= $row_rt['rat_num'] + $j;
                        } 


Once the while loop terminates $i is equal to null.

Technically in PHP 0 == NULL so the line:

PHP Code:

$d=$j/$i; 


will always be a division by 0.

One other thing: I don't understand why you are incrementing i in the while loop; it isn't a numeric value.

Hi NullPointer,

now its been solved I made used a separate if condition for percentage....now its working fine.