title: inserting data into multiple tables using php via a web form
body: <p>i have been recently studying php and mysql and also is currently developing a online web form using php and mysql. in the form i have multiple tables that i need to submit data to. i have tried this code;</p>
  
  <pre><code> $required_fields = array('event_type','accommodation_type','public_user','comments','grand_total');
      $required_fields2 = array('first_name','last_name','gender','age_group');
      $errors = array_merge($errors, check_required_fields($required_fields, $_POST));
      $errors2 = array_merge($errors2, check_required_fields($required_fields2, $_POST));
  
      $fields_with_lengths = array('event_type' =&gt; 50, 'accommodation_type' =&gt; 50, 'public_user' =&gt; 50,'comments' =&gt; 10000,'grand_total' =&gt; 50);
      $fields_with_lengths2 = array('first_name' =&gt; 50, 'last_name' =&gt; 50, 'gender' =&gt; 50,'age_group' =&gt; 50);
      $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
      $errors2 = array_merge($errors2, check_max_field_lengths($fields_with_lengths2, $_POST));
  
      $event_type = trim(mysql_prep($_POST['event_type']));
      $accommodation_type= trim(mysql_prep($_POST['accommodation_type']));
      $public_user = trim(mysql_prep($_POST['public_user']));
      $comments = trim(mysql_prep($_POST['comments']));
      $grand_total = trim(mysql_prep($_POST['grand_total']));
  
      if (empty($errors)){
          $query = "INSERT INTO event_registration (event_type, accommodation_type, public_user, comments, grand_total) VALUES ('{$event_type}','{$accommodation_type}','{$public_user}','{$comments}','{$grand_total}')";
          $result = mysql_query($query, $connection);
  
          if($result){
              $message = "The User was successfully registered";
          } else{
              $message = "The User could not be registered";
              $message .= "&lt;br /&gt;" . mysql_error();
          }
      } else{
  
          if(count($errors)==1){
              $message = "There was 1 error in the form.";
          } else {
              $message = "There were" . count($errors) . " error in the form.";
          }   
      }
  
  } else { // Form has not been submitted
      $event_type = "";
      $accommodation_type = "";
      $public_user = "";
      $comments = "";
      $grand_total = "";
  }
  </code></pre>