[RESOLVED] 'Top Searches' and 'Most Visited' Feature

[MattG]

Hi,

I want a couple of features on one of my pages, one that lists the top 10 searches that day and one that lists the top 10 most visited entries of a database.

For the later what I was thinking of doing was adding an extra field to the MySQL table and adding 1 every time the result is accessed.

For the top searches I was thinking of a database that adds the search query every time someone performs a search and listing the top ones.

However, these both seem like they could have much easier ways of doing them and I was wondering if anyone would be able to help me with something that might be easier to implement and won't be constantly hitting the database every time a page is accessed.

Forgive me if I'm being particularly dumb about this, I'll blame it on having been a long day 😃

[theelectricwiz]

hello,
Those are the easiest ways I can think of doing that. for the to 10 searches you could make it so so if the string has already been searched for it just adds one instead of inserting a new line then you can simply select the first 10 ordered by the count descending

[MattG]

Cheers theelectricwiz, should have thought about doing that for the top searches table.