<?php
include("db/cn.php");
 $total_rec = 0;
                    $query = "SELECT SUM(remain_balance) AS total_rec FROM creditor_closing ";
                    $result = $connection->query($query);
                    $row = $result->fetch_assoc();
                    $total_rec = $row['total_rec'] ?? 0;
                    
                    echo 'total Recieveable => '.$total_rec.'<br>';
                    $total = 0;
                    $q =  mysqli_query($connection,"select * from creditor_closing");
                    while($r = mysqli_fetch_array($q)){
                        $total += $r['remain_balance'];
                        
                    }
                echo  $total ; 
?>