In Progress

321165 FIX PHP/MSSQL Search

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

Skills: Anything Goes, PHP, SQL

See more: we looking for sql server developer, audio commercial, php developer questions, rebuilding, mysql mssql, mssql, mssql mysql, fix php, c# MSSQL, sql multiple questions, search google mysql, php mysql sql example, php 2008 windows, asset php, fix listing, search server, keywords searched, searched keywords, search ranking, sql keyword, category fix, windows 2008 mysql php, video audio sql, quick note windows, audio video sql

About the Employer:
( 31 reviews ) United States

Project ID: #2066971

Awarded to:

hindiphaj

Can do this, Arsen

$90 USD in 5 days
(133 Reviews)
6.2