multiple table inserts

[Anon]

I have a MYSQL database with three tables
1. text abstracts
2. category
3. text abstracts category

with 1 - 3 as one to many and 2 - 3 ad one to many. ie a text abstract can belong to many categories and category can have many abstracts.

The problem is that I would like the user to be able to select multiple categories when entering the data. (i.e. an abstract could fall under the category of email and networking).

Obviously I can't use a combo-box or dropdown box for multiple selections. Is my only solution to query the category table and display within a loop tick boxes on the screen with an array taking the result?(i.e. 0/1) then concatenate this to the insert into statement?

Any enlightnement as to an easy solution would be welcome

[mattw]

You can use a select element and allow multiple selections. syntax:

<SELECT MULTIPLE name="name">
<OPTION>...</OPTION>
</SELECT>

Matt Wade
codewalkers.com