[RESOLVED] Last Time on loop

[NZ_Kiwis]

This loops all the places i've been to

Thailand
Singapore
Sydney

But on the last one i want to change join.gif to end.gif

How can i do this?

<?php
$result2 = mysql_query ("SELECT * From travel_trips");
while($row2 = mysql_fetch_array($result2)) {
?> 
<img border="0" src="images/join.gif" width="18" height="18">
<img border="0" src="images/folder.gif" width="16" height="16">
<a href="photos.php?trip=<?php echo $row2['trip_id']; ?>"><?php echo $row2['destination']; ?></a>
<?php
}
?>

[ClarkF1]

<?php
$result2 = mysql_query ("SELECT * From travel_trips");
$count = mysql_num_rows($result2);
$counter = 0;
while($row2 = mysql_fetch_array($result2)) {
if ($counter == $count - 1)
{
echo "<img border=\"0\" src=\"images/end.gif\" width=\"18\" height=\"18\">";
}
else
{
echo "<img border=\"0\" src=\"images/join.gif\" width=\"18\" height=\"18\">";
}
?>
<img border="0" src="images/join.gif" width="18" height="18">
<img border="0" src="images/folder.gif" width="16" height="16">
<a href="photos.php?trip=<?php echo $row2['trip_id']; ?>"><?php echo $row2['destination']; ?></a>
<?php
$counter++;
}
?>