title: Cannot insert data into mysql table via php
body: <p>I'm sure this question has been asked a thousand times but after an hour of truly trying many examples on the web, I have failed to insert new data into my table. I have tried many methods as I said, the one I'm about to post is most recent. If anyone knows why my code is failing it would save so much stress. I have only so far managed to insert data via phpmyadmin. The database is called "test" and the table is called "getting". Please note that "key" is auto incremented.</p>
  
  <p>Thank you</p>
  
  <pre><code>$username='****';
  $password='****';
  $database='test';
  
  
  
      $con= mysql_connect("localhost",$username,$password);
  
       mysql_select_db("test",$con);
  
  
  
  
      mysql_query("INSERT INTO getting (Key, Date, amount, tax, Extra) 
      VALUES ('', 'sept 26 2008', '35653', '46', '454')");
  </code></pre>