douhuiwan5141 2015-03-26 20:16
浏览 47

Dreamweaver的SQL代码无法正常工作

Dreamweaver generated som sql-code that's not working. I believe this is where the error originates from:

$insertSQL = sprintf("INSERT INTO gjestebok (tidsstempel, tittel, navn, tekst) VALUES (NOW(), (%s, %s, %s)",
                   GetSQLValueString($_POST['tittel'], "text"),
                   GetSQLValueString($_POST['navn'], "text"),
                   GetSQLValueString($_POST['tekst'], "text"));

When I try to insert it into my database it shows me this message:

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 '' at line 1

Can someone spot the error?

Edit: Found the mistake. It was the "(" in front of the first "%s" I had to remove.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 三因素重复测量数据R语句编写,不存在交互作用
    • ¥15 微信会员卡等级和折扣规则
    • ¥15 微信公众平台自制会员卡可以通过收款码收款码收款进行自动积分吗
    • ¥15 随身WiFi网络灯亮但是没有网络,如何解决?
    • ¥15 gdf格式的脑电数据如何处理matlab
    • ¥20 重新写的代码替换了之后运行hbuliderx就这样了
    • ¥100 监控抖音用户作品更新可以微信公众号提醒
    • ¥15 UE5 如何可以不渲染HDRIBackdrop背景
    • ¥70 2048小游戏毕设项目
    • ¥20 mysql架构,按照姓名分表