Jump to content

[SOLVED] mysql error on Update statement


karnegyhall

Recommended Posts

if ($rowAth==$rowAth1) {
echo mysql_query("UPDATE tblathletepics SET (strPicPath ='$target', intPicID ='NULL') WHERE 

intAtheleteID =$ID") or die(mysql_error());

 

I'm getting the following:

"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 '(strPicPath ='upload/SDC10224.JPG', intPicID ='NULL') WHERE intAtheleteID =23' at line 1"

 

what am i doing wrong?

Link to comment
https://forums.phpfreaks.com/topic/164099-solved-mysql-error-on-update-statement/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.