[PHP] select the most repeated value in a field

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 [EMAIL PROTECTED] There is

[PHP] select the most repeated value in a field

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 [EMAIL PROTECTED] There is

RE: [PHP] select the most repeated value in a field

-Original Message- From: Jacky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 4:03 AM To: [EMAIL PROTECTED] Subject: [PHP] select the most repeated value in a field 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

Re: [PHP] select the most repeated value in a field

select result,count(*) as cnt from table group by result order by cnt desc ; - Original Message - From: Jacky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 10:02 PM Subject: [PHP] select the most repeated value in a field Hi people How do i query to select

Re: [PHP] select the most repeated value in a field

the goal you've set for yourself - Original Message - From: George E. Papadakis [EMAIL PROTECTED] To: Jacky [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 2:56 AM Subject: Re: [PHP] select the most repeated value in a field select result,count(*) as cnt from table