PHP脚本不适用于我的db [duplicate]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I've written following php script:

$sql = "SELECT * FROM `URLs` WHERE `durchsucht` = \'0\' LIMIT 0, 1 ";
$result = mysqli_query($db, $sql);

$row = mysqli_fetch_row($result);

$URL = $row['URL'];
echo $row['URL'];

unfortunately I get this error:

'mysqli_fetch_assoc() expects parameter 1 to be mysqli_result boolean given'

I've already got another table (within the same db) and there works this code... I appreciate every answer!

</div>

Answer 1

Your result set may have zero records, so you can make use of $result->num_rows to check whether result set has data or not

if ($result->num_rows > 0)
{
     $row = mysqli_fetch_row($result);
     $URL = $row['URL'];
     echo $row['URL'];
}