Trying to do a MySQL INSERT into a database
<p>I am trying to do a MySQL INSERT into a database with the following code:</p>

<pre><code>mysql_connect($dbserver, $dbuser, $dbpass) or die ("Unable to connect to the database.");
mysql_select_db($dbname) or die ("Unable to select db");

mysql_query("INSERT INTO $dbtable(id, IPADDRESS, MERCHANT_ID, CONNECTIONMODE_ID, OPERATOR_ID, TIMESTART, DATESTART, TRANSDATA_CHECKRESULT, TRANSACTION_CHECKRESULT, CONNECTION_STATUS, CONNECTION_SECURITYCHECK, ERRORMESSAGE_POSTEDDATAINVALID, DATEEND, TIMEEND, TRANS_ID) 
VALUES ('[value-1]', '[value-2]', '[value-3]', '[value-4]', '[value-5]', NOW(), NOW(), '[value-8]', '[value-9]', '[value-10]', '[value-11]', '[value-12]', '[value-13]', '[value-14]', '[value-15]')"); 

mysql_close();
</code></pre>

<p>If I copy the INSERT INTO direct in to SQL it works, but I have tried several different variations and non of them work.</p>
