Hi all,

I need some advice about how to structure my database. It's a MySQL db and I use PHP to interact with it. The project is a business directory.

I have a table which contains all the business info such as name,tel,email,web,text,category. I also have a category table that contains the category names, such as construction, i.t, retail etc.

The problem is, I want to be able to have a business appear under several categories, not just one. At the mo an ID of the category is stored in the business info table, this ID refers to a category name in the category table.

I was thinking i could store more than one value in the category field e.g. '1,4,2,5' then split them when needed. Or having more fields in the table such as cat1,cat2,cat3. What do you think?

Thanks all