Search Database With Checkbox Option

IN PROGRESS
Bids
16
Avg Bid (USD)
$124
Project Budget (USD)
$30 - $250

Project Description:
Search Database With Checkbox Option

SOFTWARE USED Adobe Dreamweaver CS4 (prefer if it's done with DW but not required)

DATABASE MySQL client version: 5.0.51 DB Type MyISAM

LANGUAGE PHP Version 5

WEB PAGES:
http://seelowprices.com/search/keyword/
http://seelowprices.com/search/keyword/results/

SCREEN SHOTS
http://seelowprices.com/images/gaf/SQL_statement_Dreamweaver.jpg
http://seelowprices.com/images/gaf/products_table_structure.jpg
http://seelowprices.com/images/gaf/search_page.jpg
http://seelowprices.com/images/gaf/results_page.jpg
---------------------------------------------------------------------------------------------------

GOAL ONE:
Create a SQL Statement to search in the "products" table for any word or words in the "producttitle" column and return the results back according to relevance of the request.

EXAMPLE A:
If the user types "bird dog cat" in the keywordfield and submits the keywordform:
Relevance of the request....
3 word combinations should come 1st in search results. rendering any "bird dog cat" "bird cat dog" "dog bird cat" combination
2 word combinations should come 2nd in search results. rendering any "bird dog" "dog cat" "bird cat" combination
1 word results should come 3rd in search results. rendering "bird" or "dog" or "cat"

EXAMPLE B:
If the user types "bird" in the keywordfield and submits the keywordform:
Relevance of the request....
1 word combination should come 1st in search results. rendering "bird"
2 or 3 word combinations should come 2nd in search results. rendering any "bird dog" "bird cat" "bird dog cat" "bird cat dog" "dog bird cat" combination
LIMIT results of 900 for any given search.

GOAL TWO:
With use of this checkbox called "searchcheckbox" on the bottom of the search form, ....create a SQL statement (script) to search for any word or words in the following 7 columns in this order: "producttitle, productnumber, manufacturer, upcstocknumber, details1, details2, details3". Return results back according to relevance of the request (as stated above). It is important that producttitle should have the highest column of relevance.
LIMIT results of 1200 for any given search.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

INFORMATION PROVIDED:
Above, I have provided what I believe is all the information regarding this project with exception to login information to the FTP & database. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

SELECTION PROCESS:
Not required but it is very helpful when the service provider explains in very short detail the results of your work in completing this project here. Let me know which version of Dreamweaver you use (if any).

Skills required:
Apache Solr, MySQL, Oracle, 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.


$ 200
in 5 days
Hire abraham66
$ 49
in 1 days
Hire wildlily980
$ 70
in 2 days
$ 150
in 3 days
$ 100
in 0 days
$ 125
in 2 days
Hire nmppatel
$ 250
in 5 days
Hire extremewebindia
$ 250
in 7 days
Hire freddyho
$ 80
in 3 days
Hire phprocks
$ 150
in 5 days