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.

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!