I gang

Improve Advanced search for oscommerce

This project requires a programmer to improve the OSCommerce advanced search - It needs to be able to search by alphabetical order, title and manufacturer

examples:

search in title : List results from title start with 'A' where keyword are 'monitor' AND category ='electronics' AND format ='---'

search in manufacturer : list results from manufacturers start with 'A' where keyword are 'son' AND category ='electronics' AND format ='---'

This project is to improve this sql:

select distinct p.products_image, p.products_quantity, p.products_model, m.manufacturers_name, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], s.specials_new_products_price, p.products_price) as final_price from products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id left join manufacturers m on p.manufacturers_id=m.manufacturers_id left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%son%' or p.products_model like '%son%' or m.manufacturers_name like '%son%' or p2pef.products_extra_fields_value like '%son%') ) and ((p2pef.products_extra_fields_value like '%todos%' AND p2pef.products_extra_fields_id = 2) ) order by pd.products_name

and the form and [url removed, login to view] file

Færdigheder: MySQL, OSCommerce, PHP

Se mere: oscommerce advanced search alphabetical, to advanced, manufacturer search, manufacturer order, electronics programmer, advanced search results, p sql, son, search file, null, manufacturers list, search categories, sql keyword, sql select order, manufacturer list oscommerce, oscommerce list manufacturers, form search, join file, improve php form, oscommerce manufacturers categories, advanced project php, oscommerce order products category, oscommerce search sql, advanced needs, advanced php project

Om arbejdsgiveren:
( 2 bedømmelser ) MOLINA DE SEGURA, Spain

Projekt-ID: #959977

Tildelt til:

kev2me

I can help modify your search options.

$80 USD på 1 dag
(116 bedømmelser)
6.4

13 freelancere byder i gennemsnit $61 for dette job

humashahid80

kindly check pmb.

$50 USD på 1 dag
(55 bedømmelser)
6.9
cstl

pls go through pmb

$49 USD in 2 dage
(18 bedømmelser)
6.9
techfortune

Osc Guru at your service. Ready to start now. Awaiting for your selection. Thanks !!

$75 USD in 2 dage
(94 bedømmelser)
6.3
getndone

Please check pm

$165 USD in 3 dage
(41 bedømmelser)
5.5
swamiwebservices

we can do this

$60 USD på 1 dag
(78 bedømmelser)
5.4
binhtq

Hi, I have more than 4 years with Oscommerce. I can do it. Best Regards

$80 USD på 1 dag
(19 bedømmelser)
5.0
istankov85

Hi, falasbu,Please see PM. Regards, Ivan Stankov

$30 USD på 1 dag
(37 bedømmelser)
5.0
resourcesnode

Fast change, great project for me.

$50 USD på 1 dag
(12 bedømmelser)
4.0
maturesteps

please check pmb..

$35 USD på 1 dag
(2 bedømmelser)
3.8
developerhari

Hello , please check PMB , thanks

$40 USD in 2 dage
(10 bedømmelser)
3.2
Almadad

Please See PM...

$50 USD på 1 dag
(4 bedømmelser)
2.1
xahoor

Hi, Please check your PMB.

$30 USD på 1 dag
(0 bedømmelser)
0.0