$orderby = "ORDER BY cust_bill.$field";
}
- $search{'newest_percust'} = 1 if $cgi->param('newest_percust');
-
if ( $cgi->param('newest_percust') ) {
$search{'newest_percust'} = 1;
$count_query = "SELECT COUNT(DISTINCT cust_bill.custnum), 'N/A', 'N/A'";
'$%.2f outstanding balance',
];
}
- $count_query .= " FROM cust_bill $join_cust_main $extra_sql";
+ $count_query .= " FROM cust_bill $join_cust_main WHERE $extra_sql";
$sql_query = {
'table' => 'cust_bill',