OK, picture this. I have a single database table as the back-end for a page's content (PHP). Updating this using a form is pretty simple, and so is getting the values from the DB to generate content through PHP.
Let's say I make the table with the following fields:
headLine
bodyText
citation1
info1
citation2
info2
citation3
info3
citation4
info4
citation5
info5
citation6
info6
As you can see, the fields named beginning with "citation" or "info" are going to be things in the same HTML format. Those fields represent the individually-formatted halves of a two-part section, and each overall record of the table may have from one to six of these two-part sections associated with it.
So, while I realize this is a rather bulky way of doing things, I ask: can I do it this way? Will I be wasting space, or is it alright to just allow null values for those fields when they are not all used? Again, I'm not talking about a lot of data, only ONE of these table records each month.
Appreciate any insight.
