If I where doing this for myself this is how I would do it (In basic detail as exactly what you need is not totally clear):
I would create a login page, an admin page for adding/editing executive board members. When a member is added an email could be auto sent to the members email address along with a user and password and a note to tell them to login and change the password to something they prefer.
The admin person could select a member for President for 2008, 2009, 2010 etc. and then automatically when it is that year the President information reflects the President for that same year, if a year is approaching and a president is not selected for that coming year then an email alert could be sent to the admin person reminding them of this.
When a member logged in to their account they could only update their information and not that of other members while the admin person could access all members information.
I would use Freeway to build the pages for this and then include the php scripts (a line of php code) needed to run the dynamic and admin side. This does not display the database but rather pulls the information you need from the database and displays that information.
The information would be displayed on the Freeway pages by using a small amount of php code placed in a markup item between php tags at the location of where you want this information, a line something like: echo $member_name; would show the members name while: echo $member_address: would show the members address. The page that shows this information would have an include line of code at the start of the page to run the php script to retreive the information for the selected member or show who the current president is.
To do the above you would of course need to learn some PHP and how to integrate it in scripts to manipulate a MySQL database, for adding, editing and removing data and then learn how to use this in Freeway. To be honest it isn’t even just as simple as learning how to use these as being able to use PHP and accessing a MySQL database is only the small part of it, you then need to learn how to keep it all secure which is actually what can take up the time when writing the scripts.
There are content management systems out there that you may be able to do this with, to be honest I have never looked at any of these myself as * I * am happy working in PHP and MySQL building everything I need from the ground up which gives me more control over what I can do and because I enjoy working in PHP and MySQL but maybe the CMS would be much less of a learning curve for you if you wanted to do this all yourself, maybe someone with experiance in CMS will pipe in to let you know if this is possible and recommend a system.
If you need someone to develop something for you in php and MySQL then ask for people on the list to contact you as there are a few members that could do this and who might be interested. What it appears you need is not complicated and should not take a developer much time to knock up so depending on what this is for it may be worth paying a third party developer to do it for you, rather than getting involved in the learning process.
HTH
Mike
freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options