Actually the design is in the code below.... I need to display the
counts from all of those queries in a grid. Basically, its just a
summary of a bunch of information. Another way to look at it would be
a several lines that say something like this:
You have $data1_count NEW records in data1,
You have $data1p_count PROCESSED records in data1,
etc.
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
On Jun 28, 2006, at 1:56 PM, dpgirago@xxxxxxxxxxxxxx wrote:
Kevin Murphy asks:
The following code works and accomplishes what I need it to do, but I
am wondering if there is a better way to accomplish the same task. I
have several tables of records and I need to count and then display.
Even if I could just combine the first three queries (below) into one
that would probably be a lot better than what I am doing now.
$data1_query = "select id from data1 WHERE status = ''";
$data1_results = mysql_query($data1_query);
$data1_count = mysql_num_rows($data1_results);
$data1p_query = "select id from data1 WHERE status = 'p'";
$data1p_results = mysql_query($data1p_query);
$data1p_count = mysql_num_rows($data1p_results);
$data1h_query = "select id from data1 WHERE status = 'h'";
$data1h_results = mysql_query($data1h_query);
$data1h_count = mysql_num_rows($data1h_results);
echo "<tr>";
echo "<td align=\"center\" valign=\"top\">$data1_count</
td>";
echo "<td align=\"center\" valign=\"top\">
$data1h_count</td>";
echo "<td align=\"center\" valign=\"top\">
$data1p_count</td>";
echo "</tr>";
Then do the same thing for the second table, and so on.
$data2_query = "select id from data2 WHERE status = ''";
$data2_results = mysql_query($data2_query);
$data2_count = mysql_num_rows($data2_results);
$data2p_query = "select id from data2 WHERE status = 'p'";
$data2p_results = mysql_query($data2p_query);
$data2p_count = mysql_num_rows($data2p_results);
$data2h_query = "select id from data2 WHERE status = 'h'";
$data2h_results = mysql_query($data2h_query);
$data2h_count = mysql_num_rows($data2h_results);
echo "<tr>";
echo "<td align=\"center\" valign=\"top\">$data2_count</
td>";
echo "<td align=\"center\" valign=\"top\">
$data2h_count</td>";
echo "<td align=\"center\" valign=\"top\">
$data2p_count</td>";
echo "</tr>";
Kevin,
You haven't said what you want the page to look like, but you could
have a
html select box of "letters" (a,b,c,d...) that would allow for the
selection of multiple items, then grab the values out of the array
created
and add them to the select query, and loop through it:
$data1_query = "select id from data1 WHERE status
= '$value_from_letter_array'";
Then process as you have done.
Or you could use a checkbox array...
Does that help any?
David
