mysqli select query适用于FF，不适用于Chrome，IE或Edge

Question

谁能明白为什么这个SQL查询在Firefox中有效，但在Chrome或Edge中不起作用。在Chrome和Edge中，我收到以下错误：

警告：mysqli_fetch_assoc(( 期望参数 1 mysqli_result，布尔值在第 154 行的/home/mydomain/public_html/apps/2018/index.php 中给出

$query_ArrayLookup = "SELECT SeqID FROM ".$SequenceNo_default." WHERE SeqActive = 0";
$ArrayLookup = mysqli_query($link,$query_ArrayLookup);
$ArrayLookupCount = $ArrayLookup->num_rows;
while ($row_ArrayLookup = mysqli_fetch_assoc($ArrayLookup)){ // Line 154
    $ActiveSeq[] = $row_ArrayLookup['SeqID'];
} 

Answer 1

试试这个：

$query_ArrayLookup = "SELECT SeqID FROM `{$SequenceNo_default}` WHERE SeqActive = 0";
$ArrayLookup = mysqli_query($link,$query_ArrayLookup);
$ArrayLookupCount = $ArrayLookup->num_rows;
while ($row_ArrayLookup = mysqli_fetch_assoc($ArrayLookup)){ 
    $ActiveSeq[] = $row_ArrayLookup['SeqID'];
} 

它在边缘和谷歌浏览器，IE上运行良好。