Page 1 of 1

mysql hates me, undefined error!!!!

Posted: Fri Feb 05, 2010 3:30 pm
by cap2cap10
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: :arrow: Posting Code in the Forums to learn how to do it too.


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());
 
Here is the 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 '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: :arrow: Posting Code in the Forums to learn how to do it too.

Re: mysql hates me, undefined error!!!!

Posted: Fri Feb 05, 2010 4:00 pm
by cap2cap10
Please disregard!! bone headed mistake.

Thanks again,

Batoe