Hi,
I need some custom PHP and SQL coding to develop chained selects to work with my cubecart store & database.
The work will involve creating code for:
- Integration of drop down boxes on cube cart store front
- mechanics of the dropdown search query itself
- query results page
Thanks
K
## Deliverables
Hi,
I need some PHP script and SQL? database amends, such? that a user can? filter? the? drop down / chained select? filters? to return multiple products depending on their suitability for a specific vehicle.
The script must integrate with cubecart 4, and the drop downs must be driven by the database, and not coded within a text file as the drop downs must change according to the database.
There should be 4 dropdown filters and they must filter the entire? product range? in the following heirachy? ?
Make
Model & Engine Size
Age
As such the DropDown will work as follows:
1) "Make" (All variants shown) - Ford Selected by User
2)"Model" (Only Ford Variants shown as driven by selection above) - Focus 1.9 TDi selected by user
3) "Age" (Only ages? which match FORD AND Focus 1.9TDi shown) - user selects 2000-2002 <One label>? ?
Search returns only products in this particular row called out in the SQL database which have products called out, and displays in cubecart page that will work seamlessly with the current purchase process.