This is where I do my php experiments. Right now I'm working on a new project. The following are my plans to automate the reviews procedure for Hyperrhiz and Rhizomes by creating a form-entry site using PHP and MySQL. I've been inspired by Jet's work at Pumpkin Moon. Young Jedi, you have surpassed me.

Requirements:

• Two password-protected pages, one for admin and one for reviewers. Admin will enter the initial details and reviewers will be able to submit their reviews online. Hopefully I can work out how to do a couple off email auto-reminders: one to remind the editor when the project/paper has been in review for {n months} and needs to be checked on; and one to notify the editor when a review is posted.

For editor entry:

• name of project
• author
• contact
• date (notify after time passed to check on status of reviews)
• name of reviewer 1
• name of reviewer 2
• status (etc)
• action
• comments 1
• comments 2

For reviewer entry:

• choose name of project from drop-down box
• choose reviewer name from drop-down box
• enter decision
• enter comments
• auto-notify the editor when review is submitted

Tricky:

• email notification
• keying name of project and reviewer name
• keying action & comments
• what about resubmits - new table - how to constrain
• what to do about nulls