Re: Show total records based on criteria
| From: | pete M | Date: | Wed, 12 Nov 2003 13:50:44 +0000 |
| Subject: | Re: Show total records based on criteria | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-169269@lists.php.net to get a copy of this message | ||
Tim Winters wrote:
select EyeColor, count(eyeColor) from males
group by eyecolor
;-)
Hello, Sorry for the probably newbie question. Is there a way to show the number of records in a recordset based on a specific criteria? For example, if I create a record set of all male employees regardless of eye color and then I want to create a table showing the totals of people of each eye color. Is there a way to do this with out creating several different recordsets. Thanks!! Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com webmaster@samplingtechnologies.com csnm@samplingtechnologies.com Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115