This topic is locked

Many to Many relationships

6/17/2009 12:47:03 PM
PHPRunner General questions
X
xen01 author

when you look at the live demo 1 here:

Live demo 1 - add product

you can see that you can select multiple categories for each product, but it actually saves only one category
I want to be able to select multiple categories:

So I need to list categories names and from categories table, but after selection add records to products_categories table.
as an example, if i select 2 categories (with ids 2 - 3 as eg) for a product (with id 2), it should be recorded to products_categories table like:

id, prod id, cat id

1 2 2

2 2 3
how can i achieve this?
thanks

J
Jane 6/18/2009

Hi,
please check this thread:

http://www.asprunner.com/forums/index.php?showtopic=10766
We'll fix issue with live demo.