New Category Browsing Feature
I have an existing website http://tinyurl.com/yforzds that we need to offer a new way for customers to browse by Gender, Type, and Style. The website uses PHP and Smarty templating. The urls must be SEO friendly like our current urls are. You can use some type of array logic I am thinking like domain.com/page.php?filter=12,34,34. This will allow the script to support an unlimited level of filtering.
See example at http://tinyurl.com/ya2nox2.
Our system provides a way to classify PRODUCTS/ITEMS with an option called ITEM TRACKING. It uses three tables to create item tracking.
They are: TRACKING_CATEGORIES, TRACK_GRP, AND TRCK_CHOI.
1. TRACKING CATEGORIES
a. TRACKING GROUP
i. TRACKING CHOICES
You are only working on the browsing functions and displaying by collection, you will be using existing code that displays my items and pricing. You will not be working on any ITEMS PAGES. I will assist you with the SQL queries via instant messenger. I have attatched the file category.php, and functions.php so you can see the existing code that you will be utilizing.
If you open the file CATEGORY.php you will see the code already done.
You can create a new file using this template.
YOU WILL NOT CHANGE ANY EXISTING FUNCTIONS. YOU CAN ADD NEW Functions
to THE FUNCTIONS.PHP FILE AT THE END OF THE FILE AND PLEASE COMMENT
All code below $r_items = get_items($c); should be copied into your script.
The function get_items will be replaced with your new function that must get the same information as get_items but limit it to the requested limitations(Such as Womens, Shoes, Slip On).
It of course should group them on the page by collection.
Once you have the database outputting the content correctly I can format it visually for the website you just need to get the information outputting the same way http://tinyurl.com/ya2nox2 is showing it.
I need this job done ASAP and you must be able to talk online on MSN, or Yahoo. Thank you.