why is header() function displaying A sql error
<pre><code>&lt;?php
include_once( 'mysqlconnect.php' );

$id=$_POST['id']; //8

header("location:settings_pay_roll.allowance.general.view.php?id='$id'");

?&gt;
</code></pre>

<p>output:</p>

<blockquote>
  <p>You have an error in your SQL syntax; check the manual that corresponds to your //MySQL server version for the right syntax to use near '8''' at line 1</p>
</blockquote>

<p>I know my error is at the <code>?id='$id'</code> but what I don't understand and my question is: why is it displaying output: You have an error in your SQL syntax?...</p>
