sorry, not getting it.
my sql statement is as follows...
$Recordset1 = new WA_MySQLi_RS("Recordset1",$PowerCMSConnection_i,4);
$Recordset1->setQuery("SELECT tbltestimonials.* FROM tbltestimonials");
so my limit is 4
Can you show me how to show rows 5-8 in a repeat region, is the offset done in the sql statement or in the repeat ?