[SOLVED] Why am I only getting one result back instead of many?

[brooksh]

Can someone tell me why I'm only getting 1 result back?

 

$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

[akitchin]

it's because you're replacing the $result resource that you're looping on, within the loop.  rename your $result variable within the while() loop and you'll be able to process the entire resultset.

[brooksh]

Of course. Thanks so much. Sometimes I overlook the easiest things.