how to use LIMIT / OFFSET - sql

I have a Database table ( see 'screenshot-1' ) where I want to select certain rows and display the data.

So for example If I want to query the database and select row 3 I am using the following recordset:

<?php
$rsBlock3 = new WA_MySQLi_RS("rsBlock3",$RTMFi,2,1);
$rsBlock3->setQuery("SELECT application_blocks.* FROM application_blocks WHERE application_blocks.applicant_id = ? ORDER BY application_blocks.block_id ASC");
$rsBlock3->bindParam("i", "".$_GET['appID'] ."", "-1"); //WAQB_Param1
$rsBlock3->execute();
?>

But this does not seem to work I just get the first row in the table.

Am I missing something here?

Thanks in advance

Length is first and position is second... so if you want to select 1 row at position 3 you would use:

$rsBlock3 = new WA_MySQLi_RS("rsBlock3",$RTMFi,1,3);

This doesn't appear to work for me for some reason I have used three recordsets with the following:

$rsBlock3 = new WA_MySQLi_RS("rsBlock3",$RTMFi,1,1);
$rsBlock3 = new WA_MySQLi_RS("rsBlock3",$RTMFi,1,2);
$rsBlock3 = new WA_MySQLi_RS("rsBlock3",$RTMFi,1,3);

All give me the same result.

I've attached page and relevant screenshots

Thanks in advance

What version of rsobj.php are you using?

Hi ray..
I'm using version 2.27

Try using the latest version that I've attached and let me know if you get the same results.

Thanks Ray that has corrected the issue!