php - 希望 COUNT 在 PHP MYSQL 中返回一个 0 或 1

Question

我有几行代码没有给我预期的答案。

请帮我写出最好的方法:

if ("SELECT COUNT (*) FROM completed WHERE userid = $memid AND filetid = $fileid1 LIMIT 1"){
    if (1) goto enz;
}

我想要如果 count = 1 goto enz , else (count is 0)并且继续剩下的程序

Answer 1

这样试试:

$sql = "SELECT COUNT (*) as count FROM completed WHERE userid = $memid AND filetid = $fileid1 LIMIT 1";

if ($result = mysqli_query($con,$sql)) {
    while ($row = mysqli_fetch_assoc($result)) {
        if($row['count'] == "1"){
          //Enter you code here to goto 'enz'
        } else {
          //Continue with rest of program
        }
    }
}