PDA

View Full Version : Choosing More Than One Category


Byronwells
01-29-2010, 08:28 PM
Alright Guys

I am not sure if I have to do anything to my mysql database structure..

At the moment when I create a new category it is stored under smp_category table.. Then when I to add a product to the membership that information in that category is then shown in the smp_products table under category field..

My question is on the add/edit product pages I have change the drop down menu to be able to select multiple categories to put it under.. I can choose and then submit it without out no problems..

But for some reason it is not showing up.. It is still showing up under one category... Do I have to do something to the structure of the database?? Or is this a php problem please??

Old Pedant
01-30-2010, 01:13 AM
Do I have to do something to the structure of the database??
How can we guess without knowing the existing structure???

But if you don't have any way of connecting those two tables other than the one field in smp_products, then the answer is "yes". You need a many-to-many table and you probably shouldn't have that category field in the smp_products table.