On our public web page we have a "Board Membership" list page with about 60 Board Members listed with their title, organization, web page and board position. We also have a "Staff Directory" that just lists 50 or so staff by name, job title and telephone number.
What I'd like to do is maintain the list of board members and info in a SQL table and the list of staff and phone numbers in another SQL table and generate the HTML table from the database. That way I can provide a data input form for the secretary to update the lists and I can generate the table and post it very quickly.
Board Membership Table format (repeat 60 times):
<span style="font-weight:bold;">FirstName LastName</span><br />
<a target="_blank" href="http://www.webpage.com"><strong>Organization</strong></a>
Staff Directory Format (repeat 50 times):
<td><a href="mailto:Username@AlwaysSameDomain.com"> FName LName</a><br />