[SOLVED] Query problem

[thefollower]

Im not sure what i got wrong here but im getting this error:

ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'When)
				Values ('1', '2007-12-04 00:01:55')' at line 1

 

My query :

$query = "INSERT INTO `unauthorized` (UserID,When)
				Values ('{$_SESSION['Current_User']}', '$Date')";
	mysql_query($query) or die(mysql_error());

[pocobueno1388]

I think "when" might be a mysql reserved word. Try changing it to this

 

$query = "INSERT INTO `unauthorized` (UserID,`When`)
      Values ('{$_SESSION['Current_User']}', '$Date')";
mysql_query($query) or die(mysql_error().'<p>'.$query);

[cooldude832]

this is a good list of what NOT to use in your field names

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

 

it should be added to the sticky.