Update Search Engine for our Website(repost)

Hi, There are two parts to the project. Part 1: Please see the following webpage: <[login to view URL]> As you can see, this page allows customers to search and filter by keyword, title, image code, dimensions, and price. We also want to add 5 new categories: Subject, genre, decor, primary color, and secondary color. These options would have dropdown boxes. I have attached a comma delimited file which contains the new search data for the "Subject field". For example, if you look at the "subject table", "American Houses" is represented in our database by the number "10". "Animation" = 37. "Automobiles/Trucks" = 60 and so on. There are tables for each criteria as follows: "subject" - integer -1 and higher representing various subjects. "genre" - integer -1 and higher representing various genres. "decor" - integer -1 and higher representing various decors. "prime" - integer -1 and higher representing various primary colors. "secondary" - integer -1 and higher representing various secondary colors. (-1 means the record has not yet been examined for subject, color, genre etc). The current search syntax can be found in [login to view URL] (will be attached on awarding of bid - current search written using Coldfusion). The idea is for users to be able to search for one or more options at a time, just like they can do with the current advanced search method. They could search for "Automobiles/Trucks" that are $20 and 20 x 30 inches big etc, or just Automobiles/Trucks alone etc. Part 2: See attached doscuments I look forward to your bids. Paul ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Cold Fusion