Re: How to count same text results from DB?

What is your question? How to count the result? select count(*) from users where age=18 or select count(*), name,age from users where age=18 ----- Original Message ----- From: Vojtech Dvorak <vojtech_dvorak@servind.cz> To: <php-db@lists.php.net> Sent: Tuesday, October 03, 2000 8:37 AM Subject: [PHP-DB] How to count same text results from DB? > Hi, > I have made select such as > SELECT name, age > FROM users > WHERE age=18 > > I need to have at final something like: > There is 27 Johns, 30 Pauls, 13 Marks etc. > > But few problems to make it harder: > 1) I can't use more than one select, because this database is very slow (M$ > Access) > 2) I don't know names in database (in that case I would make If $name==John > {$john++} clauses) > > I was thinking about fetching all names in array and than count it > somehow.... > Please PHP Gurus help. > Thx > Vojtech > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >