CodeIgniter Forums
I want to make a "Frequent searches" engine. ¿directions? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: I want to make a "Frequent searches" engine. ¿directions? (/thread-33477.html)



I want to make a "Frequent searches" engine. ¿directions? - El Forum - 08-27-2010

[eluser]zreedeecom[/eluser]
Hi, this post is just to know if anyone here has done something similar and what do you think about the right way to do that.

My first idea was start storing every word in the db ignoring words with 2 or less characters and every time a word is repeated just add one to a counter row (say importance) to appear first on the list of frequent searches. Sounds good until you think that normally you search for various words not just one word, eg.: big house, you may want to store "big house" as a frequent search not "big" and "house".

I'm a little bit confused about how to do that and do it right.

Any directions would be very appreciated.

Thanks in advance.