Re: Count Many Records

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@mdanderson.org 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 > >