When I have clients who need to easily add and modify the content of their website, I'll usually just set them up with Macromedia Contribute. If a more robust solution is needed, I'll go third party Content Management Systems or just build a custom setup.
I suppose this is why I don't have the nickname "Mr. Dynamic." No, that moniker goes to Miki Watts' predecessor, who came up with this database-driven solution for a customer who needed a way to easily modify content.
Table: tblContentPage | |
CatCode | |
Structure | |
CatName | |
CatOrder | |
CatDesc | |
ContentsDetails1 | includes the raw html for one part of the page |
IncR1 | |
IncR2 | |
ContentsDetails2 | includes the raw html for the second part of the page |
google_inc | |
IncMid1 | |
IncMid2 | |
ContentsDetails3 | more raw html |
ContentsDetails4 | even more raw html |
A | |
MenuUpMain | |
MenuUpSub | |
SpaceBetwenMenu | |
MenuBotton | |
ColorBotton1 | |
ColorBotton2 | |
Pic1 | |
ColorMid1 | |
ColorMid2 | |
ColorTop1 | |
ColorTop2 | |
Col1W | Width of columns in the page |
Col2W | |
Col3W | |
Col4W | |
Col5W | |
Col6W | |
Col7W | |
Col8W | |
Col9W | |
Col10W | |
Col11W | |
R1 | Height of rows in the page |
R2 | |
R3 | |
R4 | |
R5 | |
R6 | |
R7 | |
R8 | |
R9 | |
R10 | |
BG1C1 | Background color of cells, with BGxCy where x is row and y is column |
BG1C2 | |
BG1C3 | |
BG1C4 | |
BG1C5 | |
BG1C6 | |
BG2C1 | |
BG2C2 | |
BG2C3 | |
BG2C4 | |
BG2C5 | |
BG2C6 | |
BG3C1 | |
BG3C2 | |
BG3C3 | |
BG3C4 | |
BG3C5 | |
BG3C6 | |
BG4C1 | |
BG4C2 | |
BG4C3 | |
BG4C4 | |
BG4C5 | |
BG4C6 | |
BG5C1 | |
BG5C2 | |
BG5C3 | |
BG5C4 | |
BG5C5 | |
BG5C6 | |
BG6C1 | |
BG6C2 | |
BG6C3 | |
BG6C4 | |
BG6C5 | |
BG6C6 | |
BG6C7 | |
BG6C8 | |
BG6C9 | |
BG6C10 | |
BG6C11 | |
BG7C1 | |
BG7C2 | |
BG7C3 | |
BG7C4 | |
BG7C5 | |
BG7C6 | |
BG8C1 | |
BG8C2 | |
BG8C3 | |
BG8C4 | |
BG8C5 | |
BG8C6 | |
BG9C1 | |
BG9C2 | |
BG9C3 | |
BG9C4 | |
BG9C5 | |
BG9C6 |
Basically, each page has a potential for 100 cells, as a ten by ten table. And naturally, this is all done through Access. Be thankful you don't have to see the code; Miki gets to maintain it.