There is a chunk of code that has been removed from the results page.
if you look at the Bear_ResultsBACKUP.php page at line 144 - 158 the code for the WADAbear recordset looks like:
mysql_select_db($database_wibuckbear, $wibuckbear);
$query_WADAbear = "SELECT * FROM bear ORDER BY BScore DESC";
setQueryBuilderSource($query_WADAbear,$WADbSearch1,false);
$query_limit_WADAbear = sprintf("%s LIMIT %d, %d", $query_WADAbear, $startRow_WADAbear, $maxRows_WADAbear);
$WADAbear = mysql_query($query_limit_WADAbear, $wibuckbear) or die(mysql_error());
$row_WADAbear = mysql_fetch_assoc($WADAbear);
if (isset($_GET['totalRows_WADAbear'])) {
$totalRows_WADAbear = $_GET['totalRows_WADAbear'];
} else {
$all_WADAbear = mysql_query($query_WADAbear);
$totalRows_WADAbear = mysql_num_rows($all_WADAbear);
}
$totalPages_WADAbear = ceil($totalRows_WADAbear/$maxRows_WADAbear)-1;
on the Bear_Results.php page, the code for the recordset is at line 144 - 149:
mysql_select_db($database_wibuckbear, $wibuckbear);
$query_WADAbear = "SELECT * FROM bear ORDER BY BScore DESC";
setQueryBuilderSource($query_WADAbear,$WADbSearch1,false);
$WADAbear = mysql_query($query_WADAbear, $wibuckbear) or die(mysql_error());
$row_WADAbear = mysql_fetch_assoc($WADAbear);
$totalRows_WADAbear = mysql_num_rows($WADAbear);
This section of code has been removed:
if (isset($_GET['totalRows_WADAbear'])) {
$totalRows_WADAbear = $_GET['totalRows_WADAbear'];
} else {
$all_WADAbear = mysql_query($query_WADAbear);
$totalRows_WADAbear = mysql_num_rows($all_WADAbear);
}
$totalPages_WADAbear = ceil($totalRows_WADAbear/$maxRows_WADAbear)-1;