PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in

The problem is your query returned false meaning there was an error in your query. After your query you could do the following:

if (!$result) {
    die(mysqli_error($link));
}