dougai3418 2011-12-27 23:40
浏览 18
已采纳

我的SQL语法有什么问题?

$query = mysql_query("INSERT INTO comments (sender, receiver, $question) VALUES ('$sender', '$receiver', '$question')")or die(mysql_error());

error being received is...

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 'question sending) VALUES ('1', '1', 'Testing question sending')' at line 1

  • 写回答

2条回答 默认 最新

  • douba3943 2011-12-27 23:43
    关注

    You have $question for the column name (Which is becoming "Testing question sending"), when it should probably be just question (no $).

    INSERT INTO comments (sender, receiver, question) ...
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算