Repeat Region does not work with complex queries
Repeat Region does not work with complex queries. Only 1 row is returned. When executing the same query in MySQL Workbench, the correct number of rows are returned.
WEBASSIST CODE:
------------------------------------
$Recordset1->setQuery("SELECT * from variety LEFT JOIN testresults ON variety.variety_id = testresults.testresultsVariety_id
LEFT JOIN growingseasons ON testresultsGrowingSeasons_id = growingseasons_id
WHERE growingseasons_id = '3' ORDER BY variety.variety_id);
$Recordset1->execute();
------------------------------------
HTML/PHP Code:
---------------------------------------
<ul id="list1">
<?php
while(!$Recordset1->atEnd()) {
?>
<li><?php echo($Recordset1->getColumnVal("varietyName")); ?></li>
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
?>
</ul>
-----------------------------------------------------------
Total number of columns with the 3 tables are 44.