displaying content

Hey Ray

Just wondering how I would, using this one recordset I could return the first record as the mainImage and then any other records get displayed as a submimage within the repeat region? Cheers, Jamie

<?php
$_GET["GalleryContent"] = "gallery_".$PageContents->getColumnVal("ProductContentsID");?>
<?php
$Gallery = new WA_MySQLi_RS("Gallery",$DBConnection,0);
$Gallery->setQuery("SELECT * FROM gallery_category WHERE GalleryPage = ? AND Live = 1 ORDER BY GalleryOrder ASC");
$Gallery->bindParam("s", "".$_GET['GalleryContent']  ."", "-1"); //colname
$Gallery->execute();?>

<div class="container container-1">
        
        <a href="./images/gallery_c/<?php echo($Gallery->getColumnVal("GalleryImage")); ?>" class="responsive-picture mainIMage fancybox" data-fancybox-group="gallery"><picture><img alt="Placeholder Picture" src="./images/gallery_c/<?php echo($Gallery->getColumnVal("GalleryImage")); ?>"></picture></a>
        

		<?php
while(!$PageContents->atEnd()) {
?>
		  <a href="./images/gallery_c/<?php echo($Gallery->getColumnVal("GalleryImage")); ?>" class="responsive-picture subImage fancybox" data-fancybox-group="gallery">
		    <picture><img alt="Placeholder Picture" src="./images/gallery_c/<?php echo($Gallery->getColumnVal("GalleryImage")); ?>"></picture>
	      </a>
		  <?php
  $PageContents->moveNext();
}
$PageContents->moveFirst(); //return RS to first record
?>
		
        </div>

Just cut and paste the sub-recordset code into the repeat region and it should work fine.

Do you mean that I would need to have 2 record sets to achieve this and not be able to use just the one I have?

Sorry I didn't understand the question.

Just add this before the repeat region:

<?php
$PageContents->moveNext();
?>

sorry, that doesnt work (it stops any of the sub images from showing)....

have attached the page so you can see it in context and also a link to the live page

Do the sub images show before adding that line? Maybe the recorset has to be updated to include the sub-images? It looks like there aren't any sub-images in the recordset to begin with.

the main image and sub images all come from the same rs. mainImage and subImage are just the styling classes. I am just trying to get the first rexord returned to be shown with the class mainImage and all subsequent images to be shown with the class subImage

But it looks like the recordset is only returning one row to begin with. Does it have more rows?

in the case of the link I shared, there are 2 records (http://prntscr.com/fozrep). At the moment only the first record is showing as both the main image as well as the sub image where I want anything that is not the frst record to show as a sub image

So you should be able to show the first image with just regular bindings.

Then add the code:

<?php

$RecordsetName->moveNext();

?>

To move to the next image. Add the wrapping div or whatever for the sub-images and then add a repeat region for the recordset and it should all work.