250485 Search Assistant (Yahoo Clone)

I would like a Search Assistant similar to that of "Yahoo's" I want the visitor to be able to search as normal on my website [login to view URL], but with the script assistant showing four scrollable columns (5 results showing / 20 scrollable) of "relevant searches" per column determined by: Column 1: title keywords (extra data column) I associate with each listing, also based on "CATEGORY LEVEL" Column 2: keywords (extra data column) I associate with each listing, also based on "CATEGORY LEVEL" Column 3: keywords (extra data column) I associate with each listing, also based on "PAGE VIEWS" Column 4: relevant category level based on keywords also based on TOTAL PAGE VIEWS in category Column 1 -======- Keywords in "listing title" table values Say we'll start with 70% title 30% category (need these values adjustable by me and also the "weight" for levels must be adjustable (i.e 10 oints if 1st, 8 if second, etc.) so we can find the right combination that produces the best results) I need admin option to create these ratings based off pre-entered ratios/weights before the search assistant ever searches for them too. This would save a lot of database queries and server load as all it will be searching for is matching word/category ratings. The ratings for now should be static.. as in already created before the search is ever made and the assistant looks for data to provide. The more factors we have the better chances of getting near perfect results. So in the future columns will also have to be able to factor in rating based on extra values such as user rankings / website rankings, etc. Column 1: 40% Title 20% Category 20% User 10% Website 10% Other -=- A user searches for "Paris Hotel" Column 1: Associated Title Keywords Paris Hotel - ASSOSCIATED TITLE KEYWORDS = Paris, Hotel (2 keyword matches 1st/2nd of 2 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/6th level) Paris Hotel - ASSOSCIATED TITLE KEYWORDS = Paris, Hotel (2 keyword matches 1st/2nd word of 2 words) - CATEGORY = Accommodation » Hotels » Europe » France » Paris » (2 category matches 5th/2nd level) Hotel Paris - ASSOSCIATED TITLE KEYWORDS = Hotel, Paris (2 keyword matches 2nd/1st word of 2 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/6th level) Hotel Paris Charleboix - ASSOSCIATED TITLE KEYWORDS = Hotel, Paris, Charleboix (2 keyword matches 2nd/1st of 3 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/6th level) If the search was "Hotel Paris" and NOT "Paris Hotel" then the reverse would be 3,4,1,2 so that "Hotel Paris" titles show up first. (In the future we need an option to "combine certain words to mean "exactly the same thing", but until I can create that list, this will have to do) Column 2: -=======- Associated keywords in "listing keywords" table values.... very similar to title keywords except that I input them based on what I feel is relevant, not simply words in the title. Paris Hotel - ASSOSCIATED KEYWORDS = Hotel, Paris, France (2 associted matches 2nd/1st of 2 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/5th level) Paris Hotel - ASSOSCIATED KEYWORDS = Hotel, Paris, France (2 associted matches 2nd/1st of 2 words) - CATEGORY = Accommodation » Hotels » Europe » France » Paris » (2 category matches 5th/2nd level) Hotel Paris - ASSOSCIATED KEYWORDS = Hotel, Paris, France (2 associted matches 2nd/1st of 2 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/5th level) Hotel Paris Charleboix - ASSOSCIATED KEYWORDS = Hotel, Paris, France (2 associted matches 2nd/1st of 2 words) - CATEGORY = Regional » Europe » France » Paris » Accommodation » Hotels (2 matches 4th/5th level) Column 3: -=======- Relevant category level based on keywords in cateogry Same as the Category Rankings in Columns 1 & 2 but without the associated or title keyword rankings factored in. -=- Column 4: -======== Relevant category level based on keywords also based on TOTAL PAGE VIEWS in category Same as Column 4: but a mixture of the Category Rankings in Columns 1 & 2 and the Page Views ratings in Column 3. -=- In the future (or included in you are to it), I would like members to able to say "YES" this was what they were looking for after they arrive at the specific page clicked on and for the Search Assistant to LEARN (add an extra rating/weight) to the listing if YEs or NO. Also if the user is not a member, I want the user choices to be logged and again for the Search Assitant to learn which "listings" were right for the keyword combo they chose. These parts do not have to be dynamic, maybe a nightly run to change the ratings, but also with safeguards in case rating change somewhat drastically in one day. I only want to automatically approve "small changes" as I don't want people trying to cheat the system either by running bots, etc. -=- I think I got everything in. I hope it's enough for you to visualize the concept of what I want to do. Please let me know if you have any questions or require more clarification on any of the points I've written.