$res = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($res)) {
$term = $row["search_keywords"];
}
phpbb_popsearch is a table where i put the last search terms used in my forum search engine
my problem is that the results will be ordered by "counter" which is the number of time a term has been found.
I want to get the 5 most popular results AND THEN, AFTER, list the results alphabetically
if i sort the results alphabetically right in the sql query (replacing "ORDER BY counter" by "ORDER BY search_keywords") it will not work correctly because it will not get the 5 most popular terms but just the 5 first terms, alphabetically sorting them and ignoring the number of times the term has been found
thanks for help