What I need to figure out:
We would like to have an interactive, searchable directory of book bloggers by location.
Here are the specifications I’d like to incorporate:
1. Bloggers can register themselves using a form. Fields needed would be Contact Name, Blog name, Blog URL, contact email address, City, State/Province, Country, and 3-5 checkboxes for them to select their interests.
2. I’d like to allow a few moderators to approve these entries before they go into the public database.
3. Database should be searchable/sortable by location (country, state/province, city)
4. Ideally, there would be a “contact this blogger” button that would not expose the blogger’s email address, but would instead pop up a form that could be filled out and forwarded to the individual blogger.
5. Bloggers (who have been approved) can modify, update, or delete their listings at any time.
What is the best way to do this, especially for someone who knows very very little about databases.
Thanks.
Please email annkingman [at] gmail [dot] com, or get me on twitter at http://twitter.com/AnnKingman
