tables, compostite keys, duplicate recor

[Anon]

Not sure how to progress here, on many levels.

I have a MYSQL db with 3 tables.
Solution, solutioncategory, category, with solutioncategory holding two the id's from the other two tables.

The first problem is the the id's are primary in their own tables but I dont know how to define them as a composite key in the joining table (i.e. 1 solution can have many categorys).

Secondly, when the solutions are added to the db I would like the user to be able to select 1 or more categories for each solution. I assume that the list of catagories can be pulled from the db and displayed through an array. But how can I insert multiple rows into the solutioncategory table for each record in the solution table?

[[deleted]]

1)"The first problem is the the id's are primary in their own tables but I dont know how to define them as a composite key in the joining table "

MySQL without InnoDB does not have any foreign-key relations. If you want to us foreign-keys (and you really should) I suggest you start by reading the MYSQL manual for more information.

2) "But how can I insert multiple rows into the solutioncategory table for each record in the solution table? "

Exactly like that, you insert a new record for into solutioncategory for every link between solution and category.