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

2001-05-24 Thread [EMAIL PROTECTED]
rewarding than reaching 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 f

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

2001-05-24 Thread George E. Papadakis
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 Ho

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

2001-05-24 Thread Maxim Maletsky
-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 to be

[PHP] select the most repeated value in a field

2001-05-23 Thread Jacky
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 no

[PHP] select the most repeated value in a field

2001-05-23 Thread Jacky
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 no