mySQLi Repeat Region, how to do a nested Repeat Region?
Possible?
Got a region that first selects ParentId and Title then sets an ID veriable to use in a sub query to select all Sibilngs (the usual stuff...).
<?php
while(!$rsParent->atEnd()) {
?>
<strong><?php echo($rsParent->getColumnVal("typeName")); ?></strong><br />
<?php $subtarget = ($rsParent->getColumnVal("typeId"));
echo 'subtarget : ' .$subtarget; ?>
<br />
<?php
$rsSiblings = new WA_MySQLi_RS("rsSiblings",$rtk_i,1);
$rsSiblings->setQuery("SELECT tblinvtype.typeId, tblinvtype.typeName FROM tblinvtype WHERE tblinvtype.`typeSibling` = ?");
$rsSiblings->bindParam("i", "".$subtarget ."", "75"); //target
$rsSiblings->execute();
?>
<ul>
<?php
while(!$rsSiblings->atEnd()) {
?>
<li><a href=#"><?php echo($rsSiblings->getColumnVal("typeName")); ?></a></li>
<?php
$rsSiblings->moveNext();
}
?>
</ul>
<?php
$rsParent->moveNext();
}
?>