select the most repeated value in a field
| From: | Jacky | Date: | Thu, 24 May 2001 19:02:35 +0000 |
| Subject: | select the most repeated value in a field | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54172@lists.php.net to get a copy of this message | ||
Hi people
How do i query to select the most repeated values in a field, say if I hacve list of values as
a,b,c,d,e to be submitted to a field call "result" in a table. And I want to know which
value appear most in that "result" field amoung all records.
cheers
Jack
jacky@activelifestyle.com
"There is nothing more rewarding than reaching the goal you've set for yourself"