<?php 
include('config.php');

?>
<table class="table table-border">
	<tr class="bold">
    	<td>Customer Name</td>
		<td>Email</td>
		<td style="width:250px;">Address</td>
		<td>Phone No</td>
        <td>Contact Name</td>
    </tr>
<?php
   	$sql = "SELECT * FROM mst_customer ORDER BY cust_name ASC";
	$sql_con = $conn->query($sql) or die($sql);
	while($rs = $sql_con->fetch_assoc()){
?>
	<tr>
        <td><?php echo $rs['cust_name']?></td>
        <td><?php echo $rs['cust_email']?></td>
        <td><?php echo substr($rs['cust_addr'],0,100)?>...</td>
		<td><?php echo $rs['cust_phoneno']?></td>
        <td><?php echo $rs['cust_pic']?></td>
    </tr>
<?php } ?>
</table>