Advise On Corrrect Way

[lesmith]

Hello Peeps I am a little rusty on php.

Just want to ask what you think would be the right way to go about this.

Ok i have a database of users.

Now lets say I want to know what hobbies they enjoy.

So would I create a set of tick boxes.

Then collect the data from a form and put them into an array within the user database.

Then loop through that array to show the results.

Or would you suggest a better way.

Advice would be fantastic.

Lee

[devinemke]

sounds like a many-to-many data relationship (multiple users can have multiple hobbies). you should use 3 tables: users, hobbies and a third table to link them togther using the PK fields from the other 2 tables.