Code: Select all
$DB_site->query("UPDATE їIGNORE] ftpdata (threadid,ip,path,port,pass,user) VALUES('$threadid','".addslashes($ip)."','".addslashes($path)."','".addslashes($port)."','".addslashes($pass)."','".addslashes($user)."')");Invalid SQL: UPDATE [REPLACE | IGNORE] ftpdata
mysql error: You have an error in your SQL syntax near '[REPLACE | IGNORE] ftpdata at line 1
mysql error number: 1064
i used [ignore] because it's supposed to ignore the fact that threadid has the same value, and therefore be a-okay, when i dont use ignore this is what i get:
Invalid SQL: UPDATE ftpdata (threadid,ip,path,port,pass,user) VALUES('****','****','****','****','****','****')
mysql error: You have an error in your SQL syntax near '(threadid,ip,path,port,pass,user) VALUES('****','****' at line 1
plz guru HELP