$owner = $_SESSION['role'];
     $query = "SELECT l.AddressCode,
                l.owner,
                l.City,
                l.State,
                l.Zip,
                i.RefNumber,
                i.memo,
                i.Txndate,
                i.DueDate,
                i.ItemCustomerFullName,
                i.PO_number ,
                i.ItemAmount,
                i.PO_number,
                i.preorder_,
                i.Quantity,
                i.Vendor,
                i.balance
                FROM imw_locations l
                INNER JOIN vzw_invoice i
                ON l.AddressCode=i.ItemCustomerFullName
                WHERE l.owner='" . $owner . " '
                AND Txndate BETWEEN '".$sdate."' AND '".$edate."'


                ";
     $result = mysqli_query($con,$query);