I think my problem relates to this post so here is my question.
I have a photos page and photos categories and I want the photos categories to repeat and under each categories are images in that category. And I want the images to repeat.
My code for the two recordsets
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$connsqli,0);
$Recordset1->setQuery("SELECT * FROM photos_category, photos WHERE photos.photos_category = photos_category.category_name ORDER BY photos_category.category_name");
$Recordset1->execute();
?>
<?php
$Recordset2 = new WA_MySQLi_RS("Recordset2",$connsqli,0);
$Recordset2->setQuery("SELECT * FROM photos WHERE photos.photos_category = ?");
$Recordset2->bindParam("s", "".($Recordset1->getColumnVal("category_name")) ."", "-1"); //var1
$Recordset2->execute();
?>
And the code for the repeat regions
<?php
$wa_startindex = 0;
while(!$Recordset1->atEnd()) {
$wa_startindex = $Recordset1->Index;
?>
<span class="category"><?php echo($Recordset1->getColumnVal("category_name")); ?></span><br />
<br />
<?php
$wa_startindex = 0;
while(!$Recordset2->atEnd()) {
$wa_startindex = $Recordset2->Index;
?>
<div align="center"><a href="photos/<?php echo($Recordset2->getColumnVal('photos_file')); ?>" rel="lightbox" title="<?php echo($Recordset2->getColumnVal("photos_alt")); ?>"><img src="photos/<?php echo($Recordset2->getColumnVal("photos_file")); ?>" /></a></div>
<?php
$Recordset2->moveNext();
}
$Recordset2->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
This only shows the repeat from Recordset1 for any category that has images but the images do not repeat and the only image shown is in multiple categories?
Help Please.