MySQLi not returning LIMIT offset properly.
I am creating a page with an infinite scroll, and a feature of the ajax page is to return a subset of rows, with an offset.
I struggled for a while, with a mysqli recordset, so I created the recordset with the 'old' method, and it works fine.
here is a snippet of the recordset in mysqli
<?php
$rstestimonials = new WA_MySQLi_RS("rstestimonials",$PowerCMSConnection_i,$load, 3);
$rstestimonials->setQuery("SELECT tbltestimonials.TestimonialID, tbltestimonials.TestimonialTitle, tbltestimonials.TestimonialContent, tbltestimonials.TestimonialAuthor FROM tbltestimonials");
$rstestimonials->execute();
?>
and the working code from the 'old' method
$query_Recordset1 = "SELECT tbltestimonials.TestimonialID, tbltestimonials.TestimonialTitle, tbltestimonials.TestimonialContent, tbltestimonials.TestimonialAuthor FROM tbltestimonials LIMIT ".$load.",3";
where the $load variable is an integer, which 'should' increment by 3, each time the ajax is called