MySQL error when submitting php

Lee · #1 (**permalink**) 06-13-2007, 09:38 AM

I get the following error when i fill in my form:

Code:

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 ('Username', 'pass', 'emailwillbehere', 'UK')' at line 1

Here is the code for this section:

PHP Code:

  $usr = $_POST['usr'];
$pwd = $_POST['pwd'];
$email = $_POST['email'];
$from = $_POST['from'];

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);

$query = "INSERT INTO users (usr, pwd, email, from) VALUES ('$usr', '$pwd', '$email', '$from')";

mysql_query($query) or die(mysql_error());

(obviously im not showing the conection variables.)

I dont know what i am doing wrong, can anyone help me with what my error maybe?

TeraTask · #2 (**permalink**) 06-13-2007, 11:27 AM

"from" is a reserved word, so if you want to use it as a field name, you need to put backticks around it:

$query = "INSERT INTO users (usr, pwd, email, `from`) VALUES ('$usr', '$pwd', '$email', '$from')";

Or make it fully qualified:
$query = "INSERT INTO users (usr, pwd, email, users.from) VALUES ('$usr', '$pwd', '$email', '$from')";

Though, I'm a little less sure about the last suggestion. The first suggestion is a definite.

Lee · #3 (**permalink**) 06-13-2007, 12:16 PM

Thanks so much, i had been looking for a couple of hours for a answer on this, i will remmeber this for next time, cheers mate.

Nutter · #4 (**permalink**) 06-13-2007, 12:41 PM

Fields named desc used to catch me all the time. I had the habit of naming fields the shortest I could get away with - since gotten out of that habit. So instead of description I would use desc. It would sometimes work, and sometimes not.

Once I finally realized what was happening I had to thump myself on the forehead.

Lee · #5 (**permalink**) 06-13-2007, 12:50 PM

Yeah i knew it would be something simple i just couldnt find the answers anywhere but now i will know to check the names are not pre-used and if they are to use the back ticks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode