321165 FIX PHP/MSSQL Search
This project was awarded to hindiphaj for $90 USD.Get free quotes for a project like this
We are currently rebuilding a site currently active which searches through an SQL database of video and audio clips. The main method of searching the system is via keyword. We need to have it modified so that the results are displayed based on relevancy, similar to Google.
To clarify, currently in the system if a user searches using the entry 'holiday toys' the system provides results of ALL assets containing either one of the search words (holiday OR toys in this case). Instead, what SHOULD happen is first in the results should be any commercial containing BOTH words, then afterwards, spots should be listed containing just one or the other.
Essentially we want to use the Google approach, where the results are listed based on relevancy to the search.
Quick example: 3 keywords searched:
Results listing in order:
[url removed, login to view] containing all 3 keywords
[url removed, login to view] containing any 2 of the 3 keywords
[url removed, login to view] containing any 1 of the 3 keywords
Each asset has multiple attribues in the DB (director, agency, category, etc. The system is correctly searching all of these fields. The search needs to utilize all field when doing the relevancy ranking.
Looking for a developer who can do this right away, and has experience in RELAVANCY based searching.
Note: This system is Windows 2008 server, PHP with MSSQL 2008, NOT mySQL.
Thanks, and please leave any questions in PMB
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online