i updated the results page to fix the probelm, this peace of code was before the recordset:
<?php
$currentPage = $_SERVER["PHP_SELF"];
?>
<?php
$queryString_WADAtblHorse = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WADAtblHorse") == false &&
stristr($param, "totalRows_WADAtblHorse") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WADAtblHorse = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_WADAtblHorse = sprintf("&totalRows_WADAtblHorse=%d%s", $totalRows_WADAtblHorse, $queryString_WADAtblHorse);
?>
I moved it to be after the recordset.