title: Sending data from custom wordpress form to custom table not working
body: <p>I seem to have a problem with my php code. I created a template on wordpress and put in a php script that collects data from users and sends it to a custom table in the database. Unfortunately, for some reason the code isn't working and I don't know why.</p>
  
  <p>Upon filling the form, the "your application has been submitted" statement is echoed but for some reason the information entered is still not being sent to the database. Initially data captured from the form was being sent to the table, until i added new columns to the database table and modified this bit of code to match the changes made in the database. Everything checks out. the table (jobs) and column names in the db are exactly as you see them in this code.</p>
  
  <p>Your assistance will much appreciated.</p>
  
  <h2>code bit</h2>
  
  <pre><code>&lt;?php 
  
  if(isset($_POST['submit'])) {
  
  global $wpdb;
  $positiondesired=$_POST['positiondesired'];
  $firstname=$_POST['firstname'];
  $secondname=$_POST['secondname'];
  $email=$_POST['email'];
  $phonenumber=$_POST['phonenumber'];
  $highschoolgrade=$_POST['highschoolgrade'];
  $unicourse=$_POST['unicourse'];
  $unigrade=$_POST['unigrade'];
  $salary=$_POST['salary'];
  $skills=$_POST['skills'];
  $applicationletter=$_POST['applicationletter'];
  
  
  $wpdb-&gt;insert( 'jobs', array( 'firstname' =&gt; '$firstname', 'secondname'  =&gt; '$secondname', 'email' =&gt; '$email', 'phonenumber' =&gt; '$phonenumber', 'highschool_grade' =&gt; '$highschoolgrade', 'uni_course' =&gt; '$unicourse', 'uni_grade' =&gt; '$unigrade', 'salary' =&gt; '$salary', 'skills' =&gt; '$skills', 'applicationletter' =&gt; '$applicationletter', 'postion' =&gt; '$positiondesired' ), array( '%s', '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) );
  
  echo '&lt;h3 style="color:green;"&gt;Your application has been submitted&lt;/h3&gt;';
  } 
  ?&gt;
  </code></pre>
  
  <h2>The fields indicated in the code match the ones in my table</h2>