I have been looking for hours for this "error" in my PHP and SQL syntax. Does anyone see anything wrong?

code:

PHP Code:

mysql_query("INSERT INTO Archive (CText, TimeStamp, By) VALUES('".$this->Temp_Send_Text ."', '".$this->TimeStamp ."', '". $this->Temp_Send_UserID ."')")
or die(mysql_error()); 


p.s. Sorry if this is the wrong section of the forum.

I think this is your problem:

BY is a reserved word in mysql. If you insist on using it as a table name use backticks:

PHP Code:

mysql_query("INSERT INTO Archive (CText, TimeStamp, `By`) VALUES('".$this->Temp_Send_Text ."', '".$this->TimeStamp ."', '". $this->Temp_Send_UserID ."')")
or die(mysql_error()); 


I had thought that before, so I changed the names of the columns "From" "Text" and "Date" to "By" "CText" and "TimeStamp", but it gave me the same error. I guess I changed a reserved name to a reserved name.

It works now, thank you!

date, by, timestamp, from, text are all reserved words.

ANY word that is the name of a function, or of a column/data type is "reserved".

http://dev.mysql.com/doc/mysqld-vers...words-5-1.html