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);
?>

dagon

why not just select the first image, instead of all of them?

LIMIT 1

mtokoly

well, i want to include all of the images but only show the first one and hide the others

for instance:

image 1: <a href='$path/$image_name' rel='lightbox-test'><img src='$path/$image_name' width='140px' /></a>

image 2: <a href='$path/$image_name' class='hidden' rel='lightbox-test'></a>
image 3: <a href='$path/$image_name' class='hidden' rel='lightbox-test'></a>

that way the client side only shows the first image but when it is clicked, you can scroll through all of them using slimbox

dagon

<?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);

$i=0;
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $path = "archive/res/$id";
    $image_name = $row['image_name'];

if ($i==0) {
    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>";
}
$i++;
}

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

mtokoly

that did it!

thank you so much for the help!!

i cant tell you how long i toiled over that

thanks again!