Hi all,

If I want to store and retrieve the following data in a database, what is the optimal way to do so--I am asking specifically for the "Fruits_you_like" column?

Name
Phone_Number
Email_Address
Fruits_you_like

Fruits_you_like will consist of 30 different fruits. Would it be best to have one column for each fruit and use boolean 1/0 like this:

Name, Phone_Number, Email_Address, Apples, Oranges, Pears, Cherries, Strawberries

Or would it be better to only have four columns (Name, Phone_Number, Email_Address, Fruits_you_like)? If it is best to use only four columns, what should the Fruits_you_like column be? An array? Multi-dimensional array?

Thanks!

- Pam