php - 是什么导致此 mysql 查询错误？

Question

mysql_query ("
  INSERT INTO items 
    (index, name, description, given_by, 
     cost_to_tcs, starting_bid, auction_type) 
  VALUES
    ('{$index_number}','{$name}','{$description}','{$donated_by}',
     NULL,'{$auction_type}','{$starting_bid}')
  ") 
  or die("3: " . mysql_error());

错误:

3: 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 ''index', 'name', 'description', 'given_by', 'cost_to_tcs', 'starting_bid', 'auct' at line 1

感谢您的帮助。

Answer 1

index 为mysql保留关键字，将index用(反引号)`` ` 包起来

INSERT INTO items 
 (`index`, `name`, `description`, `given_by`,
  `cost_to_tcs`, `starting_bid`, `auction_type`) 

Reserve key words