Re: Count Many Records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux