A Mysql Question.....

[eluser]mddd[/eluser]
Ok, now you are making sense. From your original post, it was not clear to me that you meant storing the PREFERENCE in the database.

I think adding all of the fields to the users table is not a good idea. That way, you get loads of fields. The option of making a separate table is okay, but it has the disadvantage of growing every time you add a setting in the future.

You might consider making a table that is like this:

Code:

id        user_id   setting   value

Every user/setting combination has its own row in the table. That way you can add settings when you want, you'll never have to change the table design!