PHP - MYSQL - Simple but odd error

[Guest]

I have been looking at this for way to long and need another pair of eyes. Im getting this very simple error and cannot figure out why its drivining me insane.

 

//this is my mysql tried to make it nice and simple to find this problem

$query="INSERT INTO emails (To, From, Data) VALUES ('to', 'from', 'data')";
mysql_query($query) or die(mysql_error());

 

//this is the error im getting

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 'To, From, Data) VALUES ('to', 'from', 'data')' at line 1

 

Can somebody look at this for me I am at a stand still thanks

[kenrbnsn]

Enclose the field names in backticks:

<?php
$query="INSERT INTO emails (`To`, `From`, `Data`) VALUES ('to', 'from', 'data')";
mysql_query($query) or die(mysql_error());
?>

 

Ken

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[Guest]

I tried adding single quotes I never thought off adding backticks that did the trick. I could have swore I tried changing the field names but owell it works now thanks so much.