// Make sure the email address is available.
    $query = "SELECT id FROM applicants WHERE email='$e_email'";    
    $result = mysql_query ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());
    $row = mysql_fetch_object($result);
        
    if (mysql_num_rows($result) == 0) { // Available.

      $target_pathv = VITA_DIR . $e_lname . '_' . $e_fname . '_vita-'. mysql_insert_id() . '.pdf';             
      $target_paths = VITA_DIR . $e_lname . '_' . $e_fname . '_sop-'. mysql_insert_id() . '.pdf';
      $e_target_pathv = $e_lname . '_' . $e_fname . '_vita-'. mysql_insert_id() . '.pdf';
      $e_target_paths = $e_lname . '_' . $e_fname . '_sop-'. mysql_insert_id() . '.pdf'; 
            
      // Add the user.
      $query = "INSERT INTO applicants ( email, fname, lname, inst_phd, yr_phd, current_pos, interest, ref1_fname, ref1_lname, ref1_position, ref1_email, ref2_fname, ref2_lname, ref2_position, ref2_email, ref3_fname, ref3_lname, ref3_position, ref3_email, ref4_fname, ref4_lname, ref4_position, ref4_email, ref5_fname, ref5_lname, ref5_position, ref5_email, ref6_fname, ref6_lname, ref6_position, ref6_email, vita_name, vita_dir, sop_name, sop_dir, date, desired_pos, gender, ethnicity, ref1_key, ref2_key, ref3_key, ref4_key, ref5_key, ref6_key ) VALUES ('$e_email', '$e_fname', '$e_lname', '$e_inst_phd', '$e_yr_phd', '$e_current_pos', '$e_interest', '$e_ref1_fname', '$e_ref1_lname', '$e_ref1_position', '$e_ref1_email', '$e_ref2_fname', '$e_ref2_lname', '$e_ref2_position', '$e_ref2_email', '$e_ref3_fname', '$e_ref3_lname', '$e_ref3_position', '$e_ref3_email', '$e_ref4_fname', '$e_ref4_lname', '$e_ref4_position', '$e_ref4_email', '$e_ref5_fname', '$e_ref5_lname', '$e_ref5_position', '$e_ref5_email', '$e_ref6_fname', '$e_ref6_lname', '$e_ref6_position', '$e_ref6_email', '$e_target_pathv', '" . addslashes(VITA_DIR) . "', '$e_target_paths', '" . addslashes(VITA_DIR) . "', NOW(), '$e_desired_pos', '$e_gender', '$e_ethnicity', '$refid1', '$refid2', '$refid3', '$refid4', '$refid5', '$refid6' )";   
      $result = mysql_query ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());      

      // Move uploaded vita + sop to specified dir.
      if (!move_uploaded_file($_FILES['vita']['tmp_name'], $target_pathv)) {
        die('Error uploading vita');
      }
      if (!move_uploaded_file($_FILES['sop']['tmp_name'], $target_paths)) {
        die('Error uploading statement of purpose');
      }