I have a question regarding the table structure of my settings table. I've taken a look at this question: How should I structure my settings table with mysql? and I see that a lot of CMS systems and forums use this kind of structure for their settings. Selecting settings is very easy then, but how would I update the settings?
Say I have a page with a form with all the settings to change. In the DB, each setting is on an individual row , so if I have 40 settings I would need 40 update queries? If I would use the first approach (all settings in one row) I would only need 1 update query.
Is there something I'm missing here?
Thanks!