help with database...

[Anon]

I'm planning to code a multi-user guestbook. I have also planned to allow users to define "completely" the outlook of their guestbooks. Now becomes the "problem".

Should I create several tables for different kinds of settings, or should I collect all settings in one table. There will be dozens of settings which users can define.

Thanks for the help.

[toma42]

Neither. Use templates and store the very few variables each user may need in one table.

[Anon]

following on from Tom (and templates are sooo good)

If you have your table as

userid
settingname
settingvalue

then you only need one table. Each user will just have the required number of rows. Set up a default and then use the values from the table to make required changes. No value, no change.

[Anon]

I think you have one table user details with a unique userid

Other a design table with a userid and his specifications

Mandar kelkar