select the most repeated value in a field

From: Date: Thu, 24 May 2001 19:00:40 +0000
Subject: select the most repeated value in a field
Groups: php.general 
Request: Send a blank email to php-general+get-54171@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"

« previous php.general (#54171) next »