I have this script that will add up records and do percentages for each table. What I want to do is to select from all the tables and display the results per table, if there are any.
Here is the script:
$total_result = mysql_query("SELECT COUNT(*) AS number FROM $s_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 $s_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 $s_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 $s_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 $s_catagory WHERE (PROCESSEDDATE BETWEEN '$From' AND '$To') AND ACTIVE LIKE 'Y' AND FOLLOWUPCONTACT LIKE 'Y' AND FOLLOWUP2 LIKE '2' AND CALLER_ID = '$id' ");
if(mysql_num_rows($total_result5)){
$number5 = mysql_result($total_result5 , 0, 0);
}
$percentage = round($number3/$number*100,0);
echo "<table border=0 width='650' bordercolor=#5E3964>\n";
echo "<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='300' align='center'><font color=#FF0000><b>Follow-Up Completed:</b></font><b>$number5</b></td>
<td width='24' 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>\n";
And I know how to select across multiple tables:
mysql_connect("","","");
mysql_select_db("a0020386");
$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 HOLD LIKE 'N' AND FOLLOWUPCONTACT LIKE 'N' AND DEACTIVATE LIKE 'N' AND CALLER_ID = '$id' GROUP BY '$row1'";
$res2=mysql_query($sql2);
while($row2=mysql_fetch_array($res2)){
printf("<tr>
<td><a href=\"selectgroup.php?catagory=%s\">%s</a></td></tr><br>\n", $row1["catagory"],
$row1["catagory"]);
}
}
I want to know how to integrate these two so that I can see alll the records sorted by table.
Thanks in advance.
