Sql未在更新时设置值

Question

我一直在尝试使用ajax更新数据库中的orders表。我的sql似乎没有执行，或者我的语法可能有问题，我已经检查并验证了我传递的id变量是否已使用POST传递，并且当在javascript中被调用时，它会成功地发出警报。我遇到的问题是我的表没有更新。

我的php在这里

if(isset($_POST['completed_id']) === true) {
    $comp_id = $_POST['completed_id'];
    include 'http://trecoolable.koding.io/res/res_php/conn.php';  //connection successful
      $sql = "UPDATE resorder_tb SET res_complete = 1 WHERE res_id =".$comp_id;  //not updating, checked and names are correct


      echo $comp_id;  //shows when echoed into my msg in javascript
}

javascript

        $("#compacc_but").click(function(){

            var completed_id = record_id;
            $.ajax({
            url: "http://trecoolable.koding.io/res/res_php/getOrder.php",
            type: "POST",
            data: {completed_id:completed_id},    ///passing correct values               
            success: function(msg)
                        {
                            alert(msg); //alerting properly                                   
                        }
        });

Answer 1

您是否正在执行$sql语句？

Answer 2

只需像下面这样修改代码-

$sql = "UPDATE resorder_tb SET res_complete = 1 WHERE res_id =".$comp_id." "; 
mysql_qyery($sql);