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!