Navigation problem: ADODB

[teyeheimans]

He freakz,

I have a problem. Situation:

I am busy with a class with gets information from an Access database. This works fine untill now.

The connection is made with adodb:

<? 

$conn = new COM("ADODB.Connection") or die(error(__FILE__, __LINE__, "Kan geen databaseconnectie maken!")); 
$conn->open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath($this->db)); 

// maak de recordset aan 
$rec = new COM("ADODB.Recordset") or die(error(__FILE__,__LINE__,"Kan geen recordset aanmaken!")); 
$rec->PageSize = $this->max; 

// Etc..... 
?> 

I have made an 'sub'-class with gives the possibility to link an table from an other database to the main database. This also works fine, except that the navigation is 'broken'. Take a look:

http://www.agwnotaris.nl/TEST/index.php?pg=personeel

(Note: go to page 8 and then back to 7, 6, .. 1. You'll see this is not correct. Now go to the other page. Here is an exemple with works correct.)

My question: What went wrong? This problem only occurs when i link the db to another..

The source of the class:

http://www.agwnotaris.nl/TEST/includes/class.PageNavigation.txt

Hopefully you can help me.. im stuck.

Greetz,

--Teye

PS. Sorry for my english.. im from holland

[teyeheimans]

Thanx, but i have found the error:

dubble usage of $i;

<? 
for ($i = 1; $i <= $rec->PageSize && !$rec->EOF; $i +=1) { 
    // some code 
    for($i = 0; $i < count($fields); $i++ ) { 
        // code 
    } 
} 
?>

Greetz

Teye