Could not enter data: You have an error in your SQL syntax;
<p>Can someone help me out from this problem? 
Here is my PHP code but I get stuck with the error:</p>

<blockquote>
  <p>Could not enter data: You have an error in your SQL syntax; check the
  manual that corresponds to your MariaDB server version for the right
  syntax to use near ')' at line 1</p>
</blockquote>

<p>How to fix it?</p>

<pre><code>$sql = "INSERT INTO pemohon2(p_id,k_nom_siri,p_jenis_aset,p_pengguna_terakhir,p_tarikh_rosak) SELECT P_ID,K_nom_siri,P_jenis_aset,P_pengguna_terakhir,P_tarikh_rosak FROM pemohon )";

mysql_select_db('kenderaan');
$retval = mysql_query( $sql, $conn );

if(! $retval ) {
   die('Could not enter data: ' . mysql_error());
}

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