Question

I have a table with 3 columns : id, food_name, and category. For example, I have $food_name = "Amaranth grain, cooked" (there is a comma), and category = "Cereals".

I can t insert the values and have the following error:

Could not connect: 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  )
      VALUES ( Amaranth grain, cooked , )  at line 1

我要问:

$results1 = mysql_query("
  INSERT INTO " . $table . " (food_en, category)
  VALUES ( " . $food_name . " ,  " . $category . " )"
)or die(mysql_error());

我的猜测是,“阿马兰特谷、 co”中的ma正在造成一个问题,但我可以解决这个问题。 I Trial str_replace( , , , , , $food_name) and mysql_real_einski_string(. 我也许没有使用这些物品。

提前感谢。

www.un.org/spanish/ecosoc EDIT:我的确重复了“类别”,它并不完全无效或空洞(价值为Cereals/strong)。

当我印刷时,我没有使用我的频率,我得到:

INSERT INTO calories (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO carbohydrates (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO fats_and_fatty_acids (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO protein_and_amino_acids (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO vitamins (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO minerals (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO sterols (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )
      INSERT INTO other (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta )Could not connect: 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  )
      VALUES ( Amaranth grain, cooked , )  at line 1

(不同表格只是不同的表格,我希望插入一线)

Answer 1

There is no problem in your queries because of comma. Since you are inserting records to different tables, you need to separate each query with a query-separator or query-delimiter.

INSERT INTO calories (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta ); <-- Notice semi colon at end of query

INSERT INTO carbohydrates (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta ); <-- Notice semi colon at end of query

INSERT INTO fats_and_fatty_acids (food_en, category)
      VALUES ( Amaranth grain, cooked ,  Cereal Grains and Pasta ); <-- Notice semi colon at end of query

例如,我把每次问询都与semi-colon分开,并在没有问题的情况下插入询问。

Refer Fiddle here:。

Answer 2

只要在引文中(如你在座的单一引文中),你就可以在座标上 com。实际错误可能与以下事实有关:美元类别似乎要么是空洞的,要么是无效的,因为它说:

VALUES ( Amaranth grain, cooked , )

确保你响应 que问,确保它完全按照你的期望行事。

Answer 3

你们可以使用“基地”的功能,增加冲突或我sql_real_e Jersey_string,在我sql中具有任何含义的每一种特性面前放下冲突。

友情链接