$stmt = $GLOBALS['con']->prepare("SELECT `clientnumber`,`clientname`,`address1`,`address2`,`town`,`county`,`postcode` FROM `clientdetails` WHERE `contractor_number`='".$_REQUEST['contractor_number']."' AND `statuslive`='1'")or
die(mysqli_error($GLOBALS['con']));
$stmt->execute();$cc=$stmt->get_result();$stmt->close();
?>
<script>
$('#navBox').html(
    '<li class="breadcrumb-item"><a href="index.php?t=includes/master&p=contractor.php&view=list">Contractors</a><i class="fad fa-angle-double-right mx-2 mt-1" aria-hidden="true"></i></li><li class="breadcrumb-item active">Contractor List</li>'
)
</script>

<div class="row">
    <div class="col text-end">

        <div id="exportTitle" style="display:none">
            <p style="font-size:14px; font-weight:bold">EnRep Reporting System</p>
            <p style="font-size:12px"><a href="">Contractor Client List</a> : </p>
        </div>

    </div>
</div>


<style>
#datatable>tbody>tr>td {
    vertical-align: middle
}
</style>

<table id="datatable" class="table table-striped table-sm table-bordered table-hover responsive" width="100%">
    <thead>
        <tr>
            <th>Due Date</th>
            <th>Client Name</th>
            <th>Address 1</th>
            <th>Address 2</th>
            <th>Town</th>
            <th>County</th>
            <th>Post Code</th>
        </tr>
    </thead>
    <tbody>