the code to generate the pagination links:
<?php
$queryString_WADAclients = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WADAclients") == false &&
stristr($param, "totalRows_WADAclients") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WADAclients = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_WADAclients = sprintf("&totalRows_WADAclients=%d%s", $totalRows_WADAclients, $queryString_WADAclients);
?>
was above the recordset, it needed to be moved below the recordset.