How sort on "count."

[paulcj2]

I have built a report on a query that "counts" the number of search phrases, and displays them grouped by search phrase with the number of instances of each phrase. Works fine at:
http://www.kripalu.org/search_report_v2.php
if you plug in date range of 3/29 - 3/30/05

Now I have created a version to sort by "count."
However, as "count" is not a real field, the script produces an error.
http://www.kripalu.org/search_report_v3.php
Again, to test plug in date range of 3/29 - 3/30/05

Error retrieving search data from database!
Error: Unknown column 'count' in 'order clause'

 $sql = "select search_phrase, COUNT(*) AS num_search_phrase, 
found, 
found_date 
from 
search 
where 
found_date >= $startdate and found_date <= $enddate 
group by search_phrase 
order by 
count desc"; 

How can I revise the script to sort on "count?"

[kleineme]

Hi,

depending on the DB you may try

ORDER BY COUNT(*) DESC

or

ORDER BY num_search_phrase DESC

[paulcj2]

Thanks kleineme.

ORDER BY num_search_phrase DESC 

works fine.