MySQLI Nested Repeat

I've done nested repeat regions before, but that was many years ago and never with MySQLI - I was hoping for some help. I have two tables. 1) Articles which include fields id, adate, name, article. 2) Image with fields id, fk (foreign key back to articles), name. Each article can have multiple images.

Query for articles:
<?php
$rsArticle = new WA_MySQLi_RS("rsArticle",$connPIW2015_i,10);
$rsArticle->setQuery("SELECT article.id, article.adate, article.name FROM article");
$rsArticle->execute();
?>

I created a query for images, a repeat region for the articles, another repeat region for the images, then manually moved the images query and repeat regions into the articles repeat region, so the code looks like this.

<?php
while(!$rsArticle->atEnd()) {
?>
<?php
$rsImages = new WA_MySQLi_RS("rsImages",$connPIW2015_i,0);
$rsImages->setQuery("SELECT images.id, images.fk, images.name FROM images");
$rsImages->execute();
?>
<div><?php echo($rsArticle->getColumnVal("adate")); ?>,
<?php echo($rsArticle->getColumnVal("name")); ?>

<?php
while(!$rsImages->atEnd()) {
?>
<p><?php echo($rsImages->getColumnVal("name")); ?></p>
<?php
$rsImages->moveNext();
}
$rsImages->moveFirst(); //return RS to first record
?>
</div>
<?php
$rsArticle->moveNext();
}
$rsArticle->moveFirst(); //return RS to first record
?>

Not sure where to go from here. The rsImages query needs some sort of WHERE statement, but not sure what that is.

Please help,
Thanks - Jeff.

It sounds like you would need to filter the images table using the fk column and compare it to the value from the article recordset. Something like:

<?php

$rsImages = new WA_MySQLi_RS("rsImages",$connPIW2015_i,0);

$rsImages->setQuery("SELECT images.id, images.fk, images.name FROM images WHERE fk = ?");

$rsImages->bindParam("i", "".($rsArticle->getColumnVal("id"))  ."", "-1"); //LoopParam

$rsImages->execute();

?>

Thanks, you guys are awesome as usual. Needed to change $rsImages in the bindParam line to $rsArticle, and it works perfectly.

HI, I have looked and tried to work this, but I get this error "Parse error: syntax error, unexpected '""' (T_CONSTANT_ENCAPSED_STRING)"
in the line with the bindParam:
<?php
$sponsoren_img = new WA_MySQLi_RS("sponsoren_img",$miedema_i,0);
$sponsoren_img->setQuery("SELECT * FROM sponsoren_img WHERE id_alb = ? ORDER BY volgorde ASC");
$rsImages->bindParam("i", "".($sponsoren_alb->getColumnVal("id_alb"))  ."", "-1");
$sponsoren_img->execute();
?>

I feel like the error might be coming from another part of the page. I don't see an issue in the code you have provided.

I checked again, but could not find any issue either, but the error perstists. The use code is below:
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$hoofdfoto = new WA_MySQLi_RS("hoofdfoto",$miedveld,1);
$hoofdfoto->setQuery("SELECT * FROM hoofdfoto");
$hoofdfoto->execute();?>
<?php
$sponsor_main = new WA_MySQLi_RS("sponsor_main",$miedema_i,1);
$sponsor_main->setQuery("SELECT * FROM sponsor_main");
$sponsor_main->execute();?>
<?php
$sponsoren_alb = new WA_MySQLi_RS("sponsoren_alb",$miedema_i,1);
$sponsoren_alb->setQuery("SELECT * FROM sponsoren_alb ORDER BY volgorde ASC");
$sponsoren_alb->execute();?>
<?php
$sponsoren_img = new WA_MySQLi_RS("sponsoren_img",$miedema_i,0);
$sponsoren_img->setQuery("SELECT * FROM sponsoren_img WHERE id_alb = ? ORDER BY volgorde ASC");
$rsImages->bindParam("i", "".($sponsoren_alb->getColumnVal("id_alb"))  ."", "-1");
$sponsoren_img->execute();
?>

Please attach a copy of the page itself. I think the error may be lower on the page? Maybe it is in an include file.

I'd debug this by removing sections of the code until the error disappears. That will allow you to narrow down the error to a particular line of code and then it will become easier to look for the problem once you have the line narrowed down.

Removed almost everything. Still no joy. File is attached. Any assistance in this would be much appreciated.

I'd need FTP access to debug.

You remove all of the server code and the page still won't open? Same error?

I redid it like this:
<?php
$sponsoren_img = new WA_MySQLi_RS("sponsoren_img",$miedema_i,0);
$sponsoren_img->setQuery("SELECT * FROM sponsoren_img WHERE id_alb = ?");
$sponsoren_img->bindParam("i", "".($sponsoren_alb->getColumnVal("id_alb")) ."", "-1"); //colname
$sponsoren_img->execute();
?>

And now I get no errors anymore