title: Insert statement not working. transfer from one table to another
body: <p>Pretty new to PHP and MySQL.</p>
  
  <p>I have created an insert statement in my php script, to transfer a row of data from one table to the next for certain fields. Only thing is, it doesn't seem to be working?</p>
  
  <p>Can anybody see where the issue is?</p>
  
  <pre><code>&lt;?php
  
  require_once('auth.php');
  
  $host=""; // Host name 
  $username=""; // Mysql username
  $password=""; // Mysql password 
  $db_name=""; // Database name 
  $tbl_name="Instruction"; // Table name 
  
  
  // Connect to server and select database.
  mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
   mysql_select_db("$db_name")or die("cannot select DB");
  
   $Reference=$_REQUEST['Reference'];
   $Forename=$_REQUEST['Forename'];
       $surname=$_REQUEST['surname'];
   $DOB=$_REQUEST['DOB'];
   $Mobile=$_REQUEST['Mobile'];
   $Home=$_REQUEST['Home'];
   $Address=$_REQUEST['Address'];
   $Postcode=$_REQUEST['Postcode1'];
   $Email=$_REQUEST['Email'];
   $Accident=$_REQUEST['Accident'];
   $Details=$_REQUEST['Details'];
  
  
  //semi colon removed  
  $sql="INSERT INTO Triage (Reference,Forename,surname,D.O.B,Mobile Number,Home Number,Address,Postcode1,Email,Accident,Details)
   VALUES('.$Reference.','.$Forename.','.$surname.','.$DOB.','.$Mobile.','.$Home.','.$Address.','.$Postcode1.','.$Email.','.$Accident.','.$Details.')";
   $result=mysql_query($sql);
  
  
   echo "Successful";
   echo "&lt;BR&gt;";
   echo "&lt;a href='list_records.php'&gt;View result&lt;/a&gt;";
  
  
   ?&gt; 
  </code></pre>