MySQL INSERT INTO

[Plxply]

Hello,

This may be one of the most easiest questions you have received, although I have only just started to begin learning PHP and have decided to try and use a MySQL database.

I am currently experiencing issues with the following SQL command:

	$sql="INSERT INTO Mail (From,To,Subject,Message,IP,DateTime)
	VALUES ('$from','$to','$subject','$message','$ip','$date')";

The table and all appropriate fields are created, all of the variables are correctly defined and the connection to the database is successful but when ever this command is run I receive an SQL syntax error. Any help that you could provide would be greatly appreciated.

[johanafm]

Providing the actual error message inyour post is generally a good idea.

You are using unqouted reserved words. Do note that this kind of qouting is done with grave accents, aka backticks, in MySQL: `

[Plxply]

Thanks ever so much for your answer I would of never though of that on my own.