Greetings again php technorati. and yet another error has arised!
here is the code:
Code: Select all
$query_1 ="DELETE $image_name FROM js_resume WHERE candidateID = '$_GET[candidateID]'";
$result = mysql_query($query_1)or die(mysql_error());
$query = "UPDATE js_resume SET pic_stat = 'no' WHERE candidateID = '$_GET[candidateID]'";
$result = mysql_query($query) or die(mysql_query());
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 '93695412.jpg FROM js_resume WHERE candidateID = '99613631'' at line 1
Please advise.
Thanks in advance
batoe
"Many obstacles lay in the road ahead, but so does success!!" The unknown optimist.
pickle | Please use [ code=php ], [ code=text ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: