keeping duplicate rows and calculating o

razmon

I have a result table that contains duplicate values in a column which is what I want. I need to count these duplicates to get some sort of guide for recommendation. Not quite sure how to do this
example

column rsortname

aaaaa
aaaaa
bbbbbb
bbbbbb
bbbbbb
bbbbbb
ccccc
ccccc
ccccc
ccccc
ccccc
ccccc

My result needs to say that order of preference =
ccccc
bbbbb
aaaaa
Can anyone help me please
Thanks
Ray

Anon

select rsortname
from t
group by rsortname
order by count(*) desc

Some dbms may not support the above so you may have to write

select rsortname,count(*)
from t
group by rsortname
order by 2 desc

razmon

Thanks Lars
would the statement be something like
$query="select resortname from allresorts group by resortname order by count(*) desc";

and if so would I have to create a temporary table to get the results.

Really appreciat your help - I'm pretty new to this.
Kindest Regards
Ray

Anon

Yes, it would look like that. You do not need to create a temporary table. You just executes the query and fetches the result in the normal fashion.

razmon

Hi Lars
When I trie and execute the query I get a fatal

fatal error: Invalid use of group function

any ideas I know we have a time difference I'm in New Zealand my project deadline is midday today I'm so close

razmon

Hi Lars me again
I've put my dev up on the folling site
http://www.chapter3.net.nz/selecta/holiay_selecta.php
it's in debug so that I can see what's happening but the end result You can see that there are a number of hits on certain resorts. It's those resorts I want to prioritise and return approx 3/4 for selecting the resort then go to the appropriate url.