321165 FIX PHP/MSSQL Search

IN PROGRESS
Bids
1
Avg Bid (USD)
$90
Project Budget (USD)
N/A

Project Description:
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:
1.Results containing all 3 keywords
2.Results containing any 2 of the 3 keywords
3.Results 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

Skills required:
Anything Goes, PHP, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.