451738 Program Resource Database in PHP/MySQL/Apache

Project Due Date: 11/5/10 I need a resource database to be built in PHP using MySQL and Apache. The attached image is a visual workflow. Below you'll find the description for each field. Candidate Info Form Name = First Name Last Name (Text field) Title = (Text field) Keywords = (Text field) Resume = (File Attachment) URL = (Text field) Phone = (Text field, validate field so NNN-NNN-NNNN) E-mail = (Text field, validate for email) Status = (Dropdown field: Full Time, Free Lance) Comments = (5 line text box) Jobs Attached to = (See JOBS ATTACHED TO below) Job Form Title = (Text field) Date = (Date field, validate field so DD/MM/YYYY) Start Date = (Date field, validate field so DD/MM/YYYY) Job Description = (20 line text field) Candidates = (See CANDIDATES Section Below) CANDIDATES On the job form, I want to be able to attach candidates. It should be a lookup field that searches through my existing candidates (SEE SEARCH CANDIDATE FORM). Once you attach a candidate to the Job, there needs to be a Note field (5 line text box) for each new candidate. JOBS ATTACHED TO Jobs attached to needs to say what job title the candidate has been associated to and the notes that I've typed up. SEARCH CANDIDATE FORM Basically all fields in the candidate form need to be searchable. The keyword needs to be a list of existing keywords and I can select multiple keywords.