Hey guys I am in the process of making an online store. My products are stored in the db with basic table.
db.define_table('products', Field('MainCategory', 'string'), Field('SubCategory', 'string'), Field('Title', 'string'), Field('Price', 'double'), Field('image', 'upload', uploadfield='image_field'), Field('image_field', 'blob') ) Every product has a main category and a subcategory. for the means of a simple example lets say ANIMAL is a main category, CAT and DOG are subcategories. In my view I have a jQuery accordion style navigation menu that has my MainCategory and under them their SubCategories. I need the navigation menu to take the MainCategory and the SubCategory and then query the DB to select only the products that belong to those categories. Then loop through the results placing them in a table in a div of my page. I have no troubles setting everything statically to achieve what I want to do. But I would love to setup a function that i can pass arguments to to achieve the desired results. So that the website is easily expandable in the future. Thank you in advance to anyone that helps me out I will be forever greatful!