[SOLVED] Insert Error

[timmah1]

I'm getting an error with this code, and I cannot for the life of me, find it.

$sql = "INSERT INTO clients(clientID, client, clientName, date, addr, city, state, zip, company, ext, cell, fax, email, level, tax, latedays, amount, terms, days, desc, active) VALUES(
				'$clientID',
				'$client',
				'$clientName',
				'$date',
				'$addr',
				'$city',
				'$state', 
				'$zip',
				'$company',
				'$ext',
				'$cell',
				'$fax',
				'$email',
				'$level',
				'$tax',
				'$latedays',
				'$amount',
				'$terms',
				'$days',
				'$desc',
				'$active');";
				mysql_query($sql)
				or die("Sorry, there was a problem adding client ".mysql_error());

 

The error I'm getting is this

Sorry, there was a problem adding client 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 'desc, status) VALUES( '0CZS', '', '', '', '', ' at line 1

 

Can anybody spot the error?

 

Thanks in advance

[Mchl]

desc is MySQL reserved word. Either change column name, or use it in ``.

[timmah1]

I knew it had to be something simple.

Thank you mchl

[Mchl]

Well... I'm surprised that 'date' column didn't trigger it. You might want to take care of it as well.

[timmah1]

I've never had a problem with 'date', but I usually don't use it anymore, but old habits are sometimes hard to break.

Thanks again for your help