After I use that query, I got list of result group by DESC under variable
name " firstchoice", how could I index this firstchoice variable so that I
can take each individual result to display according to the page layout
position?
Jack
[EMAIL PROTECTED]
"There is nothing more 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 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 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 nothing more rewarding than reaching the goal you've set for
> yourself"
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
