I have this script that, goes through all the tables and adds up records, then displays them and percentages. The only thing is that it is still displaying even the ones that do not contain records and showing errors, when it displays a table with records it is right, how do I weed out the table that don't have the records in it.
<?php
$sql1="SELECT catagory FROM Dealers";
$res1=mysql_query($sql1) or die(mysql_error());
while($row1=mysql_fetch_array($res1))
{
$sql2="SELECT * FROM ".$row1['catagory']." WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND CALLER_ID = '$id'";
$res2=mysql_query($sql2);
for($i = 0; $i < count($res2); $i++){
$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);
}
$percentage = round($number3/$number*100,0);
printf("<tr><td><strong>%s</strong></td></tr>\n",
$row1["catagory"]
);
echo"<table border=1 width='650' bordercolor=#5E3964>
<tr>
<td width='162' align='left'><font color=#FF0000><b>Total Activated Calls:</b></font><b>$number</b></td>
<td width='162' align='center'><font color=#FF0000><b>Calls Remaining in Pending:</b></font><b>$number2</b></td>
<td width='162' align='center'><font color=#FF0000><b>Total Activated Contacted:</b></font><b>$number3</b></td>
<td width='162' align='right'><font color=#FF0000><b>% of Active Contacted:</b></font><b>$percentage</b><b>%</b></td>
</tr>
<tr>
<td width='162' align='left'><font color=#FF0000><b>Total Active Not Contacted:</b></font><b>$number4</b></td>
<td width='162' align='center'><font color=#FF0000><b></b></font><b></b></td>
<td width='162' align='center'><font color=#FF0000><b></b></font><b></b></td>
<td width='162' align='right'><font color=#FF0000><b></b></font><b></b><b></b></td>
</tr></table>\n";
}
}
?>
Thank in advance for the help.
