Hi Ray
It didn't work. For some reason, executing the $showRegister twice doesn't work. I managed to get the desired result by following your logic and adding a separate query. Not the most efficient coding though :-)
Perhaps you can add a ->MoveToLast function in future releases?
Thanks for your help. Very much appreciated!
if (!isset($_GET['pageNum_showRegister'])) {
$justForRows = new WA_MySQLi_RS("justForRows",$local);
$justForRows->setQuery("SELECT * FROM user1");
$justForRows->execute();
$_GET['pageNum_showRegister'] = ceil($justForRows->TotalRows/10)-1;
}