previous and next in odbc

[delfa]

Hi php users!

As u can guess i can´t create previous and next for odbc in access!

the main problem is that access don´t use LIMIT like mysql but instead uses TOP.

But top can´t give me the results between x and x2 , it only limits the nr of records retrieved.

my database has 3 primary keys!

can someone give me an ideia ??

[barand]

To display records 21 - 30, get TOP 30, then when reading rows, ignore first 20 before you start outputing to browser.

hth

[delfa]

hum.....that´s a good start!

but how do u ignore the first 20?

like this?

$i =0;
while (odbc_fetch_row($result))
{
$i++;
if ($i <= 20){

echo results;
}
}

than how do i interact with the previous and next buttons?

send me an example please!