SQL Syntax Error

[dapcigar]

Am trying to save into the DB. after running the query, i keep getting this error.

"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 'leave, meal, gross, tax, pension, dha, hmo, loan, surcharge, corporative, sa, ov' at line 1"

 

have tried looking for the problem but i can't find it.. here's the code below

	$que = mysql_query("INSERT INTO salary(id, firstname, lastname, basic, housing, transport, ultility, entertainment, leave, meal, gross, tax, pension, dha, hmo, loan, surcharge, corporative, sa, overtime, netpay, date, status) 
VALUES (NULL, '$firstname', '$lastname', ' $basic', '$housing', '$transport', '$ultility', '$entertainment', '$leave', '$meal', '$gross', '$tax', '$pension', '$dha', '$hmo', '$loan', '$surcharge', '$corporative', '$sa', '$overtime', '$netpay', '$date', '$status')") or die(mysql_error());	
		

Thanks in advance

[Barand]

'leave' is a MySQL reserved word. You need to enclose it in backticks (`leave`). NB - not single quotes.

 

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