Hey, Im trying to insert some values into my table, im getting this error and i cant see why =/
Error, insert query failed: 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 'use,to,from,message,subject,date) VALUES ('1','ALL','1','1','1','March 2, 2007, '
This code to insert:
$subject = $_POST['subject'];
$from = $_POST['from'];
$message = $_POST['message'];
$date = date("F j, Y, g:i a");
$conn = mysql_connect($db_host, $db_user, $db_pass) or die ('Error: '. mysql_error());
mysql_select_db($db_name);
$query = "INSERT INTO history (use,to,from,message,subject,date) VALUES ('1','ALL','$from','$message','$subject','$date')";
mysql_query($query) or die('Error, insert query failed: ' . mysql_error());