<?php
$username = " ";
$dbname = " ";
$password = " ";
$db = mysql_connect( "", $username, $password);
mysql_select_db( $customers, $db);
//Module to Display Customers
$find = "select * from customers order by customer_email";
$results = mysql_query($find);
?>
<HEAD>
<TITLE>Customers</TITLE>
</HEAD>
<BODY>
<center>
<p> </p>
<p> </p>
<p><strong><font size=12><u>Customers</u></font></strong></p>
<p> </p>
<P>
<Table border=2 width=100%>
<tr height=60>
<Td><b>Name</b></Td>
<Td><b>Organization</b></Td>
<Td><b>Address</b></Td>
<Td><b>Town</b></Td>
<Td><b>Zip Code</b></Td>
<Td><b>Country</b></Td>
<Td><b>Telephone</b></Td>
<Td><b>Email Address</b></Td>
<?php while ($row = mysql_fetch_object($results)){ ?>
<tr>
<td><?php echo $row->customer_fullname?></td>
<td><?php echo $row->customer_organisation?></td>
<td><?php echo $row->customer_address?></td>
<td><?php echo $row->customer_town?></td>
<td><?php echo $row->customer_zipcode?></td>
<td><?php echo $row->customer_country?></td>
<td><?php echo $row->customer_telephone?></td>
<td><?php echo $row->customer_email?></td>
// Continue with the rest of the details as you named them in the database
</tr>
<?php }?>
</Table>
<BR>
</center>
<BR>
</BODY>
