The recordset code is duplicated.
change lines 135 - 164:
<?php
$maxRows_WADAPayments = 1000;
$pageNum_WADAPayments = 0;
if (isset($_GET['pageNum_WADAPayments'])) {
$pageNum_WADAPayments = $_GET['pageNum_WADAPayments'];
}
$startRow_WADAPayments = $pageNum_WADAPayments * $maxRows_WADAPayments;
mysql_select_db($database_anna, $anna);
$query_WADAPayments = "SELECT PaymentsID, `Users`.`UserFirstName` AS Users_UserFirstName, Users.UserSurname, `ContractTracking`.`PackageID` AS ContractTracking_PackageID, PaymentDate, PaymentDocno, PaymentDebit, PaymentCredit FROM Payments LEFT JOIN Users ON Users.UserID = Payments.PaymentClientID LEFT JOIN ContractTracking ON ContractTracking.ContractID = Payments.PaymentContractTrackingID WHERE PaymentDebit > 0 OR PaymentCredit > 0 ORDER BY Users.UserSurname ASC, `Users`.`UserFirstName` ASC, PaymentDate ASC";
setQueryBuilderSource($query_WADAPayments,$WADbSearch1,false);
$query_limit_WADAPayments = sprintf("%s LIMIT %d, %d", $query_WADAPayments, $startRow_WADAPayments, $maxRows_WADAPayments);
$WADAPayments = mysql_query($query_limit_WADAPayments, $anna) or die(mysql_error());
$row_WADAPayments = mysql_fetch_assoc($WADAPayments);
if (isset($_GET['totalRows_WADAPayments'])) {
$totalRows_WADAPayments = $_GET['totalRows_WADAPayments'];
} else {
$all_WADAPayments = mysql_query($query_WADAPayments, $anna);
$totalRows_WADAPayments = mysql_num_rows($all_WADAPayments);
}
$totalPages_WADAPayments = ceil($totalRows_WADAPayments/$maxRows_WADAPayments)-1;
mysql_select_db($database_anna, $anna);
$query_WADATotals = "SELECT SUM(PaymentDebit) AS Debits, SUM(PaymentCredit) AS Credits, SUM(PaymentDebit) - SUM(PaymentCredit) as Balance FROM Payments LEFT JOIN Users ON Users.UserID = Payments.PaymentClientID LEFT JOIN ContractTracking ON ContractTracking.ContractID = Payments.PaymentContractTrackingID";
setQueryBuilderSource($query_WADATotals,$WADbSearch2,false);
$WADATotals = mysql_query($query_WADATotals, $anna) or die(mysql_error());
$row_WADATotals = mysql_fetch_assoc($WADATotals);
$totalRows_WADATotals = mysql_num_rows($WADATotals);
?>
to:
<?php
$maxRows_WADAPayments = 1000;
$pageNum_WADAPayments = 0;
if (isset($_GET['pageNum_WADAPayments'])) {
$pageNum_WADAPayments = $_GET['pageNum_WADAPayments'];
}
$startRow_WADAPayments = $pageNum_WADAPayments * $maxRows_WADAPayments;
mysql_select_db($database_anna, $anna);
$query_WADAPayments = "SELECT PaymentsID, `Users`.`UserFirstName` AS Users_UserFirstName, Users.UserSurname, `ContractTracking`.`PackageID` AS ContractTracking_PackageID, PaymentDate, PaymentDocno, PaymentDebit, PaymentCredit FROM Payments LEFT JOIN Users ON Users.UserID = Payments.PaymentClientID LEFT JOIN ContractTracking ON ContractTracking.ContractID = Payments.PaymentContractTrackingID WHERE PaymentDebit > 0 OR PaymentCredit > 0 ORDER BY Users.UserSurname ASC, `Users`.`UserFirstName` ASC, PaymentDate ASC";
setQueryBuilderSource($query_WADAPayments,$WADbSearch1,false);
$query_limit_WADAPayments = sprintf("%s LIMIT %d, %d", $query_WADAPayments, $startRow_WADAPayments, $maxRows_WADAPayments);
$WADAPayments = mysql_query($query_limit_WADAPayments, $anna) or die(mysql_error());
$row_WADAPayments = mysql_fetch_assoc($WADAPayments);
if (isset($_GET['totalRows_WADAPayments'])) {
$totalRows_WADAPayments = $_GET['totalRows_WADAPayments'];
} else {
$all_WADAPayments = mysql_query($query_WADAPayments, $anna);
$totalRows_WADAPayments = mysql_num_rows($all_WADAPayments);
}
$totalPages_WADAPayments = ceil($totalRows_WADAPayments/$maxRows_WADAPayments)-1;
?>
NOTE: the recordset criteria you mention is contrary to what you originally wrote, that is the basis for the confusion.
that is why I suggested using AND.