Storing an array

[blueman]

Hi All,

Here's the situation:

I have to assign multiple category_id's to a certain banner, so it can be displayed according to the category loaded on my template.

The category_id's will be collected through check boxes on a form, and the amount could vary from one to all available. There is a table for banners and a table for categories, where the primary keys (category_id) come from.

So my idea is to assign all the checked category_id's to an array, but I have no idea on how to store this array on the database.

Any suggestions?

thanx in advance,
Blueman

[drawmack]

make a third table

ban_to_cat
    id
    ban_id
    cat_id