RE: [PHP] php to generate statiscs

First article under MySQL... http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html ---John Holmes... > -Original Message- > From: Rodrigo Peres [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 11:34 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] php to ge

Re: [PHP] php to generate statiscs

Does anybody knows the link to this article or other that treats something like this. I couldn;t find it in devshed. Rodrigo on 6/2/02 3:57 PM, John Holmes at [EMAIL PROTECTED] wrote: > Look into cross-tab queries (I think that's what they are called). There > is a good article on Devshed.com

RE: [PHP] php to generate statiscs

Look into cross-tab queries (I think that's what they are called). There is a good article on Devshed.com about it. You can do a query like this SELECT SUM(IF(Gender='M'),1,0)) AS Male, SUM(IF(Gender='F',1,0)) AS Female FROM table That'll give you two columns, one named Male, one named Female, i