I keep getting syntax errors but I don't see what I'm doing wrong I think it might have to be the Date field, but I checked the documentation and I it looks right. I even tried using phpmyadmin and using the php code output and it still gave me errors. Here is my code :
$hi = '20041005';
$boo = 'Why is this not working';
$coo = 'I want a cries with my wahburger';
$Connect = mysql_connect($host, $user, $pass);
if (!$Connect) {
die('Not connected : ' . mysql_error());
}
$DBselected = mysql_select_db($DBname, $Connect);
if (!$DBselected) {
die ('Unable to select DB: ' . mysql_error());
}
$result = mysql_query("INSERT INTO $DBtable (ID, Date, Event Title, Description) VALUES ('','$hi','$boo','$coo')");
if (!$result) {
die('Invalid query: ' . mysql_error());
}
The error message i get is:
Invalid query: 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 'Title, Description) VALUES ('',20041005,'Why is this not workin
~Thanks for any help
