I am getting an error when I divide by zero, this will happen from time to time so I need it not to display the error just display 0 if I am dividing by zero.
$total_result = mysql_query("SELECT COUNT(*) AS number FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND ACTIVE LIKE 'Y' AND CALLER_ID = '$id'");
if(mysql_num_rows($total_result)){
$number = mysql_result($total_result , 0, 0);
}
$total_result2 = mysql_query("SELECT COUNT(*) AS number2 FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND HOLD LIKE 'N' AND FOLLOWUPCONTACT LIKE 'N' AND DEACTIVATE LIKE 'N' AND CALLER_ID = '$id'");
if(mysql_num_rows($total_result2)){
$number2 = mysql_result($total_result2 , 0, 0);
}
$total_result3 = mysql_query("SELECT COUNT(*) AS number3 FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND ACTIVE LIKE 'Y' AND DEACTIVATE LIKE 'N' AND CALLER_ID = '$id'");
if(mysql_num_rows($total_result3)){
$number3 = mysql_result($total_result3 , 0, 0);
}
$total_result4 = mysql_query("SELECT COUNT(*) AS number4 FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND ACTIVE LIKE 'Y' AND DEACTIVATE LIKE 'Y' AND CALLER_ID = '$id'");
if(mysql_num_rows($total_result4)){
$number4 = mysql_result($total_result4 , 0, 0);
}
$total_result5 = mysql_query("SELECT COUNT(*) AS number5 FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND ACTIVE LIKE 'Y' AND LM LIKE 'Y' AND CALLER_ID = '$id' ");
if(mysql_num_rows($total_result5)){
$number5 = mysql_result($total_result5 , 0, 0);
}
$percentage = round($number3/$number*100,0);
Thanks in advance.
