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:rperes@mac.com] > Sent: Monday, June 03, 2002 11:34 AM > To: php-general@lists.php.net > Subject: 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 holmes072000@charter.net wrote: > > > 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, in the > > result set. The result set will have one row, containing the number of > > males in the database in the Male column, the number of females in the > > database in the second. > > > > You could probably do the majority of your "statistic" queries this way. > > > > ---John Holmes... > > > >> -----Original Message----- > >> From: Rodrigo Peres [mailto:rperes@mac.com] > >> Sent: Sunday, June 02, 2002 2:02 PM > >> To: php-general@lists.php.net > >> Subject: [PHP] php to generate statiscs > >> > >> Hi list, > >> > >> Sorry if this is a off-topic, but I really don't know where to begin. > > I > >> have a mysql database with about 20.000 records, now I need to build a > >> statistics panel to show for example how many of this record are male, > >> female, lives in determinated city, school graduation etc, everything > >> grouped by sex and alone too, present the respectives percentages > > etc... > >> How do I begin??? Can someone help?? > >> > >> thank's in advance > >> > >> Rodrigo Peres > >> > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php