Hey Guys,
Apologies if this is in the wrong forum, there are a mind boggling number of sub-forums on here !
Basically, I'm developing an events management system with a slight twist, in that events can be submitted into the database online - through a php interface.
I'm happy with the php side of things, however I'm wondering the best way to go about creating an approvals process.
As it stands I have a current_projects table, with around 60 different fields in, which is related to a few different tables (contacts, dates, etc), this table should only contain approved events with approved information (checked by a single member of staff).
I'd like to set up a system whereby information can be submitted online, through a one page php script, but for it to go into a quarantine, where a member of staff in the office can check through each individual field and approve information to go into the current_projects table and fields.
Ideally once a piece of information has been submitted and approved, that field could then be locked out online.
What is the best way of doing this ?
James