how to differentiate rows

[mtokoly]

after calling an array, how do i do different each row?

i would like to show the first image in the gallery and hide the other images

<?php 
$query = "SELECT * FROM residential, res_images WHERE residential.id = $id AND prop_id = $id";         
$result = @mysqli_query ($db, $query); 
$num_rows = mysqli_num_rows($result); 

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 
    $path = "archive/res/$id"; 
    $image_name = $row['image_name']; 
     
    if (blah blah) { 
        echo "<a href='$path/$image_name' rel='lightbox-test'><img src='$path/$image_name' width='140px' /></a>"; 
    } else { 
        echo "<a href='$path/$image_name' rel='lightbox-test' class='hidden'></a>"; 
    } 
} 

mysqli_free_result ($result); 
mysqli_close($db); 
?>

[JShor]

Not too sure what you're looking to do,can you be more specific? From what I understood,you're trying to keep only the first image,and no other row results after that will have the image -- only data.

If that's the case,this should work for you:

<?php  
$query = "SELECT * FROM residential, res_images WHERE residential.id = $id AND prop_id = $id";          
$result = @mysqli_query ($db, $query);  
$num_rows = mysqli_num_rows($result);  

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {  
    $path = "archive/res/$id";  
    $image_name = $row['image_name'];  
      
    if ($firstImgCalled == 'true') {  
        echo "<a href='$path/$image_name' rel='lightbox-test'><img src='$path/$image_name' width='140px' /></a>";  
    } else {  
        echo "<a href='$path/$image_name' rel='lightbox-test' class='hidden'></a>";  
    }  

    $firstImgCalled = "true"; // this declaration will stop all other imgs from showing via the if...else statement.
}  

mysqli_free_result ($result);  
mysqli_close($db);  
?>

HTH