PHP和SQL不起作用？

Question

$sql = mysqli_query($db, "SELECT COUNT(ID) from bruker");

if (!$sql) {
    while ($row1 = mysqli_fetch_array($sql, MYSQL_NUM)); {
        echo $row1;
    }
} else {
    echo "Funker ikke";
}

I cant get it to work, all I get is the: else "Funker ikke".

Answer 1

Your code are having two error there.
First, it should be true condition only can get into the display loop. But you put the condition as !$sql means false only can get into the loop. So, you should change !$sql to $sql.

Besides, after the While loop should not direct put the semicolon.

You try see the following code

$sql = mysqli_query($db, "SELECT COUNT(ID) from bruker");

if ($sql) {
    while ($row1 = mysqli_fetch_array($sql, MYSQL_NUM))
    {
        echo $row1[0]; 
    }
} 
else {
    echo "Funker ikke";
}