<?
$host="localhost";
$database="bwclients";
$username="Paul";
$password="password";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM clients";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();



$i=0;
while ($i < $num) {

$Name=mysql_result($result,$i,"Name");
$Bday=mysql_result($result,$i,"Bday");
$Phone=mysql_result($result,$i,"Phone");
$Address=mysql_result($result,$i,"Address");
$Email=mysql_result($result,$i,"Email");
$Gender=mysql_result($result,$i,"Gender");
$Children=mysql_result($result,$i,"Children");
echo "<b><center>Database Output</center></b><br><br>";
echo "<b>$Name</b><br>Phone: $Phone<br>Address: $Address<br>Birthday: $Bday<br>E-mail: $Email<br>Gender: $Gender<br>Children: $Children<hr><br>";

$i++;
}

?>