Increase variable value in a loop - HELP!?!?

dingledow

I have an image gallery that needs to show some featured properties. I need the a href for the first image to be "#fragment-0", the next image needs to have an a href of "#fragment-1", the next one "#fragment-2" etc. etc.

This is my code:

<?php require 'config/dbc.php';
		$featuredproperty_sql = "SELECT * FROM property LIMIT 0,5";
		$featuredproperty_query = mysql_query($featuredproperty_sql) or die(mysql_error());
		$rsfeaturedproperty = mysql_fetch_assoc($featuredproperty_query);	
?>

<?php do { ?>

<?php $property_id = $rsfeaturedproperty['property_id']; $img1 = $rsfeaturedproperty['img1']; ?>

				<li class="ui-tabs-nav-item ui-tabs-selected" id="nav-fragment-1">
				<a href="#fragment-0"><img src="house2find/<?php echo $img1; ?>" alt="" width="90" height="57" /></a>
				</li>

					       <?php } while ($rsfeaturedproperty = mysql_fetch_assoc($featuredproperty_query)) ?>

Can you help me to get the #fragment-(number) to increase for each query result.

TheoGB

I think this would do it.

<?php require 'config/dbc.php';
		$featuredproperty_sql = "SELECT * FROM property LIMIT 0,5";
		$featuredproperty_query = mysql_query($featuredproperty_sql) or die(mysql_error());
		$rsfeaturedproperty = mysql_fetch_assoc($featuredproperty_query);	
?>

<?php 

$counter = 0;
do { ?>

<?php $property_id = $rsfeaturedproperty['property_id']; $img1 = $rsfeaturedproperty['img1']; ?>

				<li class="ui-tabs-nav-item ui-tabs-selected" id="nav-fragment-1">
				<a href="#fragment-<?php echo $counter++; ?>"><img src="house2find/<?php echo $img1; ?>" alt="" width="90" height="57" /></a>
				</li>

					       <?php } while ($rsfeaturedproperty = mysql_fetch_assoc($featuredproperty_query)) ?>

TheoGB

I notice you have id="nav-fragment-1" (one higher than your #fragment- number there too. I don't know if you wanted that to increase also but if so, it's a similar method.

dingledow

That seems to have worked - I just need to replicate this in another part of the code and then I will mark this thread as resolved.

Thanks!

dingledow

I don't need the nav-fragment-1 to increase, but it works brilliantly! Thanks!