Page 1 of 1

Simple novice database question

Posted: Sun Mar 04, 2007 10:17 pm
by derek barnstorm
Hi,

This is the first script that I am going to be working on, so forgive me for being a novice.
I am going to use a form like this one: http://spacerockcity.com/add_profile.html to send the information to a database (MySQL), so I can then retrieve it and display it on a profile page for my users.
My question is, would it be best for me to store all of the information in just one table, or create a new table for each form field?

Thanks,

Des.

Posted: Sun Mar 04, 2007 10:23 pm
by feyd
I see no reason to have a new table for each form field.

Posted: Sun Mar 04, 2007 10:40 pm
by derek barnstorm
Okay thanks. So, can you have as many columns in a table as you like?

Posted: Sun Mar 04, 2007 10:43 pm
by feyd
Technically, yes. However it's rare for many tables to have a lot of columns. The exact point where "a lot" happens varies depending on what you're storing.

Posted: Sun Mar 04, 2007 10:55 pm
by derek barnstorm
Right. Thanks a lot for the advice.

Des.