"; echo ""; echo "DateInvoice No Customer Amount Paid BalanceComments Actions "; echo ""; if (mysqli_num_rows($results) != 0) { // displaying records. while ($row = mysqli_fetch_array($results)) { echo ""; echo "".$row['sale_time']."".$row['invoice']. "" .$row['customer_name']. "" .$row['payment']. "".$row['received']. "".$row['balance']. "".$row['comments']. "Detail"; echo ""; } echo ""; } else { echo "No records are found."; } echo "
"; // displaying paginaiton. echo pagination($statement,$per_page,$page,$url='?'); ?>