Deleting unneeded images - Help

[brooksh]

I have my images in one table, then the data in another. I am trying to cross reference the image to see if the data exists, if it doesn't, I want to delete the image in the table, and the image itself. I wrote a script, but for some reason it doesn't seem to be working. Can anyone tell me what I'm doing wrong?

 

$sql = "SELECT id,mls,imagename FROM images";
        $result = mysql_query ($sql);
            while($row = mysql_fetch_array ($result, MYSQL_ASSOC))
        {
$id = $row[id];
$mls = $row[mls];
$imagename = $row[imagename];


$sql = "SELECT id FROM residential WHERE  mls = '$mls'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count==0){
mysql_query("DELETE FROM images WHERE mls = '$mls'");
$path = "/home/endtek/public_html/images/mlsimages/imls/$imagename";
if (file_exists($path)) {
unlink($path);
}
}//end count=0
}//end while