Thanks Dave,
It is working but it is repeating the region the number of times that there are images in the database. So if category one has four images, it repeats four times, etc.
I have two tables in db.
photos_category with two cols - category_ID and category_name
photos with four cols -photos_ID photos_file photos_alt and cat_ID
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$connsqli,0);
$Recordset1->setQuery("SELECT photos.photos_ID, photos.photos_file, photos.photos_alt, photos.cat_ID, photos_category.category_ID, photos_category.category_name FROM photos, photos_category WHERE photos_category.category_ID = photos.cat_ID ");
$Recordset1->execute();
?>
And the loop
<?php
$wa_startindex = 0;
while(!$Recordset1->atEnd()) {
$wa_startindex = $Recordset1->Index;
?>
<?php
$Recordset2 = new WA_MySQLi_RS("Recordset2",$connsqli,0);
$Recordset2->setQuery("SELECT * FROM photos WHERE photos.cat_ID = ? ORDER BY photos.photos_ID");
$Recordset2->bindParam("i", "".($Recordset1->getColumnVal("category_ID")) ."", "-1"); //var1
$Recordset2->execute();
?>
<span class="category"><?php echo($Recordset1->getColumnVal("category_name")); ?></span><br />
<br />
<div align="center">
<?php
$wa_startindex = 0;
while(!$Recordset2->atEnd()) {
$wa_startindex = $Recordset2->Index;
?>
<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>
<?php
$Recordset2->moveNext();
}
$Recordset2->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
</div>
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>