Đã hoàn thành

119856 Modify ASP/SQL Search

We have a site currently active which searches through an SQL database of TV commercials. The main method of searching the system is via keyword. The search is currently developed in an ?or' fashion, and we need to have it modified so that it uses ?and' as a parameter, and 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 commercials 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

Thanks, and please leave any questions in PMB

Kĩ năng: Bất kì công việc gì, ASP, SQL

Xem nhiều hơn: commercials commercials, fashion tv, tv commercial, sql based, asp sql, sql search asp, asp sql search, keywords searched, searched keywords, sql keyword, order entry system database, database order entry system, sql questions, sql entry, use google search results, keywords searching, google search results keywords search, database search results asp sql, order system asp, asp sql entry, sql search database keyword, search words, quick search, asp leave system, commercial spots

Về Bên Thuê:
( 31 nhận xét ) United States

ID dự án: #1866026

Được trao cho:


As discussed in PMB, thanks for considering my bid!

$75 USD trong 3 ngày
(4 Đánh Giá)