I get this error in my php scripts. Anyone know what is this error? Thanks
Error: 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 'AND project_id=' at line 1
mySQL's Error[solved]
Moderator: General Moderators
mySQL's Error[solved]
Last edited by lala on Tue Aug 24, 2010 1:25 am, edited 1 time in total.
Re: mySQL's Error
it's quite clear actually... you produced invalid SQL code. fix it or provide the entire statement for us to be able to help you.
Re: mySQL's Error
$id=$_GET['pid'];
.//SQL comment here
.
.
echo "<script language=javascript>alert(\"Records Saved\")</script>";
echo "<meta http-equiv='Refresh' content='0; url=../detail.php?id=$_GET[pid]'>";
last statement have problem:
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 '' at line 1
.//SQL comment here
.
.
echo "<script language=javascript>alert(\"Records Saved\")</script>";
echo "<meta http-equiv='Refresh' content='0; url=../detail.php?id=$_GET[pid]'>";
last statement have problem:
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 '' at line 1
Re: mySQL's Error
You need to post the sql query.