[SOLVED] MySQL INSERT ERROR

[kpetsche20]

Code:

$sql2 = "INSERT INTO mailid (mailid, subject, message, from) VALUES ('".$insert."', '".$subject."', '".$message."', '".$from."')";

 

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 'from) VALUES ('4', 'et', '', 'demouser')' at line 1

[stublackett]

Code:

$sql2 = "INSERT INTO mailid (mailid, subject, message, from) VALUES ('".$insert."', '".$subject."', '".$message."', '".$from."')";

 

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 'from) VALUES ('4', 'et', '', 'demouser')' at line 1

 

What is the value of $insert, $subject, $message and $from ?

[kpetsche20]

  $to = $_POST['to'];
  $subject = $_POST['subject'];
  $message = $_POST['message'];
  $from = $_SESSION['login'];

[kpetsche20]

Solved: Problem is "from" is an illegal column name

[toivo]

Code:

$sql2 = "INSERT INTO mailid (mailid, subject, message, from) VALUES ('".$insert."', '".$subject."', '".$message."', '".$from."')";

 

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 'from) VALUES ('4', 'et', '', 'demouser')' at line 1

 

Hi,

 

from is a reserved word and you need to quote it in backticks if you want to use it as an identifier:

 

`from`

 

Regards,

toivo

[paul2463]

just for your information chaps and chapesses, the mysql_error() code you get back tells you exactly where the problem lies, in your case

 

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 'from) VALUES ('4', 'et', '', 'demouser')' at line 1

 

"from" is the problem, and we know this because the syntax error is always the first word after the near ', that is where the fault lies, all the rest of the line of code it gives you is so that you can easily find which word it is failing on.

 

[d.shankar]

Click "Topic Solved" if ur problem is fixed.

[kpetsche20]

Where is the topic solved button