could someone help me, whats wrong with this syntax?
Posted: Thu Jul 04, 2002 6:42 am
k here goes, inputing info into a database
threadid, obviously is already there, the data is being EDITED, this is what i get
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
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