php - PHP Mysql LIMIT 查询失败

Question

我正在尝试使用包含 3 个表的连接查询来获取消息，一切正常，但是当我尝试限制结果时，查询失败并且不返回任何内容

询问

    SELECT 
        P.patient_name, 
        DM.message, 
        DM.secsince, 
        DM.id, 
        DM.pid, 
        DM.did, 
        DM.mode, 
        DM.date, 
        DM.seen 
    FROM tbl_patient P, 
        tbl_doct D, 
        tbl_doct_messages DM 
    WHERE (DM.did = D.id AND DM.pid = P.id) 
        AND (DM.mode = 'in') 
        AND (D.id = '$id') 
    ORDER BY DM.secsince DESC;

此查询工作正常，并给了我预期的结果

但是当我使用 LIMIT 它失败并且由于某种原因没有返回任何东西

询问

SELECT 
    P.patient_name, 
    DM.message, 
    DM.secsince, 
    DM.id, 
    DM.pid, 
    DM.did, 
    DM.mode, 
    DM.date, 
    DM.seen 
FROM tbl_patient P, 
    tbl_doct D, 
    tbl_doct_messages DM 
WHERE (DM.did = D.id AND DM.pid = P.id) 
    AND (DM.mode = 'in') 
    AND (D.id = '$id') 
ORDER BY 
   DM.secsince DESC; 
LIMIT=1;

这是整个php代码

<?php
include("conn.php");
if(mysqli_connect_error($con)) {
    echo "Failed To Connect";
}

$id = $_GET['id'];
$qry = "SELECT P.patient_name, DM.message, DM.secsince, DM.id, DM.pid, DM.did, DM.mode, DM.date, DM.seen 
        FROM tbl_patient P, tbl_doct D, tbl_doct_messages DM 
        WHERE (DM.did = D.id AND DM.pid = P.id) AND (DM.mode = 'in') AND (D.id = '$id') 
        ORDER BY DM.secsince DESC 
        LIMIT=1;";
$res = mysqli_query($con, $qry);
$flag = array();
while(($row = mysqli_fetch_array($res))){
    array_push($flag, $row);
}
echo json_encode($flag); 
mysqli_close($con);     
?>

正如您在这张图片中看到的那样，它给了我无限的结果

但是没有结果，所以当我添加限制时 mysqli_fetch_array 失败

为什么会这样？我基本上没有想法。

标签： phpmysql

Answer 1

因为正确的语法是LIMIT 1而不是LIMIT = 1