duanpiyao2734
2015-01-02 18:34 阅读 63
已采纳

Mysql查询更新来自php

Hi to everyone i have a problemn with a query in PHP to Update records.

 <?php
include('../webcgo/script/cox.php');
$query = $cox->query("SELECT cf_id FROM offerte;");
while ($idx = mysqli_fetch_array($query)) {
    $check = '<button class="uk-button" onclick="location.href=\'http://localhost/chartscript/remRegola.php?dis=2&id=' . $idx['cf_id'] . '\'">OK</button>';
    $query_check = 'UPDATE offerte SET check=\'' . $check . '\' WHERE cf_id=' . $idx['cf_id'].';';
    if ($queryx = $cox->query($query_check) === TRUE) {
        echo "Record updated successfully";
    } else {
        echo "Error updating record: " . $cox->error;

    }
}
mysqli_close($cox);?>

The result: Error updating record: 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 'check='

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dongsuyou6938 dongsuyou6938 2015-01-02 18:36

    check is a MySQL reserved keyword. If you're going to use it in your query you must wrap it in backticks:

     $query_check = 'UPDATE agoragroup_chronoforms_data_inserimento_offerte_prod SET `check`=\'' . $check . '\' WHERE cf_id=' . $idx['cf_id'].';';
    
    点赞 评论 复制链接分享

相关推荐