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
