Insert to table problem

[jeddiki]

What could be the reason for this failure to insert a row ?

Here is my insert code:

$sql = "INSERT INTO `products` (live,cat_cd,long,user_id,prod_name,prod_desc_sht,prod_desc_lng)
VALUES 
('$Db_live_cd','$Db_cat_cd','$Db_long_cd','{$_SESSION['expert']}','$Db_prod_name','$Db_prod_desc_sht','$Db_prod_desc_lng')";
 
echo "SQL: $sql";
 
$result = mysql_query($sql) or die("could not execute ADD a PRODUCT.". mysql_error()); 
 

This is my error message:
could not execute ADD a PRODUCT.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 'long,user_id,prod_name,prod_desc_sht,prod_desc_ln g) VALUES ('y','se','y',' at line 1

My table structure is here:

$sql = "CREATE TABLE `products` (
  `prod_id` int(4) NOT NULL AUTO_INCREMENT,
  `confirm` char(1) NOT NULL default '',
  `live` char(1) NOT NULL default '',
    `type` char(1) NOT NULL default '',
    `cat_cd` char(2) NOT NULL default '',
    `long` char(1) NOT NULL default 'y',
  `user_id` varchar(25) NOT NULL default '',
    `prod_name` varchar(40) NOT NULL default '',
  `prod_pict` varchar(25) NOT NULL default '',
    `prod_desc_sht`  text NOT NULL default '',
    `prod_desc_lng`  text NOT NULL default '',
    `prod_link` varchar(50) NOT NULL default '',
    `valid_fm_date` int(12) default NULL,
  `valid_to_date` int(12) default NULL,
    `vote_count` int(3) default '0',
    `sales_count` int(3) default '0',
     KEY `user_id` (`user_id`),
     KEY `prod_id` (`prod_id`),
     PRIMARY KEY (prod_name)
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1";
 

I can not see any reason for the failure !!!

Any ideas ?

[jeddiki]

Just found out that "long" is a reserved word so I'll change the field name.

[Atli]

Hi.

You can use reserved keywords as field/table/database names if you enclose them in back-ticks (as you do in the CREATE query).

But avoiding using them (at least by themselves) is still a good idea.