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.