Page 1 of 1

mySQL's Error[solved]

Posted: Mon Aug 23, 2010 12:41 am
by lala
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

Re: mySQL's Error

Posted: Mon Aug 23, 2010 1:12 am
by Gargoyle
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

Posted: Mon Aug 23, 2010 10:48 pm
by lala
$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

Re: mySQL's Error

Posted: Tue Aug 24, 2010 1:06 am
by agriz
You need to post the sql query.