Displaying the top 10 search phrases searched for on a site.

[Breana]

I am trying to add this to the search page so it shows the users the top 10 items searched for... like this.

Top 10 Searches:
( free, invincible, lvl skip, skin mod, car, toy, controller, sexy, buy)

[PHP]<?php

$sql = "select * from search_terms order by count desc limit 0,10";

$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

do {

printf("<tr>");
printf("<td width=250>%s</td>", $myrow["term"]);
printf("<td width=50>%s</td>", $myrow["count"]);
printf("</tr>");

} while ($myrow = mysql_fetch_array($result));

}


?>[/PHP]

It works but don't seem to update the code, with the new search tems i just posted. I want it to show only the new ones not the old ones!

[pbmods]

Breana, please read the Posting Guidelines regarding what makes a good thread title.

[kovik]

It works but don't seem to update the code, with the new search tems i just posted. I want it to show only the new ones not the old ones!

That's because you likely have a lot of searches on the older terms, so adding new ones doesn't necessarily mean they have the same amount of searches. You should make some sort of filtering by the date.