Iam in early development stages with a site. Iam having a go using PhP and Msql software. Iam wanting to capture quite alot of details from registered users. What is the recommended maximum amount of fields to use in one table. I can quite easily group the specific information into categories and use tables for these groups eg. user details, option selection etc Because I have alot of field info is it standard practice to use seperate tables? Or could I use just one table with alot of fields ? - this would be my ideal method, because I think it would be tidier to manage.
I can only use one database for this website due to the web host only allowing one database.