Thanks Ray that has worked for the repeat region.
<?php require_once('Connections/mitoWebsiteMSQLI.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$mitoWebsiteMSQLI,0);
$Recordset1->setQuery("SELECT DISTINCT completedProjects.state FROM completedProjects ORDER BY completedProjects.state ASC");
$Recordset1->execute();
?>
<?php
$Recordset2 = new WA_MySQLi_RS("Recordset2",$mitoWebsiteMSQLI,10);
$Recordset2->setQuery("SELECT * FROM completedProjects ORDER BY project_name ASC");
$Recordset2->execute();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
while(!$Recordset1->atEnd()) {
?>
<h2><?php echo($Recordset1->getColumnVal("state")); ?></h2>
<?php
while(!$Recordset2->atEnd()) {
?>
<?php echo($Recordset2->getColumnVal("project_name")); ?><br>
<?php
$Recordset2->moveNext();
}
$Recordset2->moveFirst(); //return RS to first record
?>
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
?>
I am also trying to print the projects that are listed under the state. when I go into the record set and try to set the filter to state the inner project repeat region disappears? Any advice mate?