My simple thot.<div><br></div><div>A table called section: this will hold 2fields ID and Location. Location would be what &quot;Area&quot; data can be published for eg Nairobi, Taveta etc.</div><div>Pages table: ID, Content, Section_ID, Date, Publish[boolean] (other fields can be added)</div>
<div><br></div><div>In the WYSYWYG, the end user types out data and selects its relevance depending on the Section it belongs to.</div><div>In the viewing part, hopefully using a &quot;routable&quot; mechanism, it could have a URL of <a href="http://domainwhatever/nairobi/page.asp?id=x">http://domainwhatever/nairobi/page.asp?id=x</a>.</div>
<div><br></div>