title: VAR data not pushing to SQL
body: <p>I'm having a slight issue and I'm not sure why. Maybe someone can help me out. First a few disclaimers; I'm still learning PHP, I'm aware of mysqli or pdo but the server this will live on is running an old ver 4 of php.</p>
  
  <p>Ok now on to the problem.</p>
  
  <p>I have a form which passes to my post-data.php form to push to SQL db. </p>
  
  <p>However when it pushes the data it's only pushing the variables not the data within the vars from post action of the form.</p>
  
  <p><a href="http://imgur.com/6K7FKaU" rel="nofollow">Screenshot of submitted data in PHPmyadmin</a>  </p>
  
  <p>My Code follows:</p>
  
  <pre><code>&lt;?php
      $hostname = "localhost"; $username = "goldme_owner";
      $dbName = "goldme_dealer_meeting";
  
      $connect = mysql_connect($hostname, $username);
      if (!$connect) { 
          echo "Please try later."; 
      } 
      else { 
          mysql_select_db($dbName, $connect); 
          $checkboxA1 = isset($_POST['checkboxA1']) ? $_POST['checkboxA1'] : 'No';
          $checkboxE1 = isset($_POST['checkboxE1']) ? $_POST['checkboxE1'] : 'No';
          $checkboxF1 = isset($_POST['checkboxF1']) ? $_POST['checkboxF1'] : 'No';
          $checkboxG1 = isset($_POST['checkboxG1']) ? $_POST['checkboxG1'] : 'No';
          $checkboxH1 = isset($_POST['checkboxH1']) ? $_POST['checkboxH1'] : 'No';
          $checkboxI1 = isset($_POST['checkboxI1']) ? $_POST['checkboxI1'] : 'No';
          $checkboxJ1 = isset($_POST['checkboxJ1']) ? $_POST['checkboxJ1'] : 'No';
          $checkboxK1 = isset($_POST['checkboxK1']) ? $_POST['checkboxK1'] : 'No';
      }
  
      echo "$checkboxA1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxE1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxF1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxG1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxH1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxI1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxJ1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$checkboxK1"; //just want to make sure checkbox vars are passing //will delete in final code
      echo "$_POST[confirm]"; //just want to make sure confirm code generated //will delete in final code
  
          $sql_statement = 'INSERT INTO 2014_registrations'. 
          '(confirm_number,timecode,company_name,country,address1,address2,city'.
          ',state,zip,phone,fax,email,zone_manager,transport,first_name,'.
          'last_name,tuesday_tours,tuesday_meat,wed_lunch,wed_dinner,'.
          'wed_pool_tourney,thurs_lunch,thurs_dinner,fri_shop,fri_tour,dietary)'.
          'VALUES ("$_POST[confirm]","$_POST[timecode]","$_POST[company_name]",'.
          '"$_POST[address]","$_POST[address2]","$_POST[city]","$_POST[state]",'.
          '"$_POST[zip]","$_POST[country]","$_POST[phone]","$_POST[fax]",'.
          '"$_POST[email]","$_POST[zonemanager]","$_POST[transport]",'.
          '"$_POST[fattendee1]","$_POST[lattendee1]","$_POST[checkboxA1]",'.
          '"$_POST[radio1]","$_POST[checkboxE1]","$_POST[checkboxF1]",'.
          '"$_POST[checkboxG1]","$_POST[checkboxH1]","$_POST[checkboxI1]",'.
          '"$_POST[checkboxJ1]","$_POST[checkboxK1]","$_POST[dietary1]")';
  
  
      $rec_insert = mysql_query($sql_statement);
      if(! $rec_insert ){
          die('Could not enter data: ' . mysql_error());
      }
      echo "Entered data successfully\n";
      mysql_close($connect);
  ?&gt; 
  </code></pre>