ajax运行mysql查询并检查mysql查询是true还是false - ajax run mysql query and check whether mysql query was true or false?

ajax run mysql query and check whether mysql query was true or false?

我使用以下ajax脚本运行MySQL查询，然后只希望jquery淡出我的div，如果查询返回true，则淡出另一个div，否则如果查询返回false，则不要执行任何操作。

Ajax：

<script type="text/javascript">
    $(document).ready(function () {
        $.ajax({
            type: "POST",
            url: "include/fade_to_do_list.php",
            data: "theOption=" + $(this).attr("id"), 
            dataType: 'json',//specify data type
            success: function(data3) {
                if(data3.res.indexOf("success") >-1 ){
                    setTimeout(
                        function() {    
                            $("#to_do_list").fadeOut();
                        }, 3500
                    );
                    setTimeout(
                        function() {    
                            $("#compliance_list").fadeIn();
                        }, 500
                    );
                } 
            }
        });
    });
</script>

PHP/MYSQL:

<?php 
session_start();
include 'config.php';
$query = "SELECT * FROM supplier_stats WHERE complete_count = > 3 AND user_id = '{$_SESSION['id']}'";
$result = mysql_query($query);
if(mysql_num_rows($result)>0) {
    $query2 = "UPDATE supplier_stats SET profile_complete = 'complete' WHERE user_id = '{$_SESSION['id']}'";
    $result2 = mysql_query($query2);
    if($result2) {
         $return['res'] = 'success';
    } else {
} 
}
echo json_encode($return);
?>

有人能告诉我哪里出了问题吗？我目前没有得到任何错误，我的jquery就是没有执行。感谢

mysql_query()总是给您返回一些东西。你需要count number of affected row。

同样的问题是，当等于大于运算符时，它被用作>=

$query = "SELECT * FROM supplier_stats WHERE complete_count >= 3 AND user_id = '{$_SESSION['id']}'";
$result = mysql_query($query);
$query2 = "UPDATE supplier_stats SET profile_complete = 'complete' WHERE user_id = '{$_SESSION['id']}'";
    $result2 = mysql_query($query2);
    $total=mysql_affected_rows();
    if($total >0) {
         $return['res'] = 'success';
    } else {
}