<?
$connect = mysql_connect("localhost","comp188","XXXX") or die("not connected");
mysql_select_db("comp188",$connect);
echo "
<table>
<tr>
<td>customerid</td>
<td>name</td>
<td>address</td>
<td>creditcardnumber</td>
</tr>";
$query = "select * from customer";
$result = mysql_query($query) or die("\n<br>Query:$query\n<br>Error:".mysql_error());
while ( $row = mysql_fetch_array($result) ) {
echo "
<tr>
<td>{$row[customerid]}</td>
<td>{$row[name]}</td>
<td>{$row[address]}</td>
<td>{$row[creditcardnumber]}</td>
</tr>";
}
echo "
</table>";
?>