deleting images from folder

[carnack]

I'm trying to delete images from a folder if they don't exist in a table
This is what I have so far, but it deletes ALL of the images

Getting this warning as well

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home1/americans/public_html/stampfair.com/users/aimage_test.php on line 16

Because it is deleting ALL of the images, I'm guessing the db query result is failing is failing

Note that if I run the query alone, it returns the expected result

$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");

$like = scandir('sfbuyer');     // IMAGE FOLDER
$query = "SELECT substr(value,42) FROM ppbv79_listings_media WHERE value like '%stampfair.com/users/russromei/%'"; // GETS THE FILE NAME

foreach ($like as $thisFile) {
$rs = mysqli_query($link,$query);
if (!mysqli_num_rows($rs)) {    // I KNOW THIS PART IS WRONG SHOULD BE SOMETHING LIKE if($thisFile != $like -- DOESN'T WORK
if($thisFile != "." and $thisFile != ".."){  // OR SHOULD BE HERE -- CAN'T GET IT TO ECHO VALUES SO WORKING BLIND
unlink ('sfbuyer/' . $thisFile);

}

}
}

[Barand]

One approach would be to get an array of files in the directory and another array of files from the database. Then you can use array_diff() to see which are missing.