Error when inserting

[timmah1]

Here is my code

include ('DB_config.php');
$table = 'order';
$ip = $REMOTE_ADDR;  
$query = mysql_query("INSERT INTO $table (`id` , `date`, `ip`, `f_name`, `l_name`, `email`, `phone`, `address`, `address2`, `city`, `state`, `zip`, `hear`, `objectives`, `preferred`, `f_name2`, `l_name2`, `email2`, `phone2`,`address22`, `address222`, `city2`, `state2`, `zip2`, `quantity`, `card_type`, `ccn`, `exp`, `cw`, `processed`) VALUES ('NULL','NOW()','$ip','".$_POST['f_name']."','".$_POST['l_name']."','".$_POST['email']."','".$_POST['phone']."','".$_POST['address']."','".$_POST['address2']."','".$_POST['city']."','".$_POST['state']."','".$_POST['zip']."','".$_POST['hear']."','".$_POST['objectives']."','".$_POST['preferred']."','".$_POST['f_name2']."','".$_POST['l_name2']."','".$_POST['email2']."','".$_POST['phone2']."','".$_POST['address22']."','".$_POST['address222']."','".$_POST['city2']."','".$_POST['state2']."','".$_POST['zip2']."','".$_POST['quantity']."','".$_POST['card_type']."','".$_POST['ccn']."','".$_POST['exp']."','".$_POST['cw']."','n')") 
or die("Sorry, there was a problem with your order ".mysql_error());

 

I keep getting this error

Sorry, there was a problem with your order 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 'order (`id` , `date`, `ip`, `f_name`, `l_name`, `email`, `phone`, `address`, `ad' at line 1

 

Can you please advise as to why??

 

I have used this code numerous times, different values, but the same code regardless and have never gotten this error.

 

Thanks in advance.

[marcus]

try

 

$table = "order";
$query = "INSERT INTO `".$table."` ...";

[timmah1]

Thank you.

It works

[timmah1]

Where's the "SOLVED" button?

[budimir]

On the top or in the bottom. "TOPIC SOLVED" click on it.