advanced search optimalisation

We use a search box with 3 search filters + keywords. The search box puts the search options to the file /advanced_search_result.php. This file shows the results. The total code need a make-over. Goal for this project is: move all search filters + options to [login to view URL] if else present all the search actions are done with [login to view URL] Make the search query quicker and with a lot less of code. filter options for searching; /templates/xxx/source/boxes/[login to view URL] /templates/xxx/boxes/[login to view URL] search files: /[login to view URL] /inc/[login to view URL] /includes/modules/[login to view URL] ) amount of keywords searching is set to a maximum see table configuration (now max = 3) ) filter input keywords on [a-Z0-9]/i (left spaces) ) filter db select [a-Z0-9]/i (left spaces); very important, there are many keywords like Güde (guede,gude) - 410-P(410P,410/P,410_P) visitors can type complete different then what is stored in the db. ) if there is no filter option selected or option = 0 then remove the empty filters from the url; like "&manufacturers_id=&cat=&sorting_id=" ) if url has this options "&pfrom=0&pto=4500" then remove this options also from url, because that is the default setting when filtering on price ) add extra search select box option "check_global", default = 0, if 1 then search through all categories ) $_GET['sorting_id'] does not work correct, test every id to see what happens ) if no results than the class fuzzy_search has to start and show possible products. with a max. of 15 products. test with "sjpo" ) use the [login to view URL] only for getting the parameters for searching. the results are shown with /advanced_search_result.php. this also means that all the search codes in [login to view URL] can be wiped. ) in [login to view URL] there is also $_GET['sorting_id'] - $_GET['filter_id'] - $_GET['manufacturers_id'] and more. these also have to ) no error codes in the url. now so now and then I see $errorno - $error ) fine-tune $breadcrumb in [login to view URL] and wipe all not used or 0 parameters, like &categories_id=, &manufacturers_id=, etc. If you have excellent skills in MYSQL + PHP + Oscommerce (it is xtcommerce code, but nearly the same as Osc, only php code + html are separated) and able to get this project done this coming week, then please do a bid. A good developer should take maximal 12-15 hours for this project. Keep this in mind when bidding. There are some import issues to mention when we agree with you: 1) copyrights are owned by us 2) project milestone of 80 USD by starting 3) rest payment after finishing project 4) project duration 3 days after Won bid is set 5) communication via mail/skype 6) developing on our server 7) it is forbidden to download other files then the files I will send