<?
$DBhost = "";
$DBuser = "";
$DBpass = "";
$DBName = "xyz";
$table = "abc";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
// print " <TITLE>Solutions Prosper </TITLE>
//<BODY BGCOLOR=\"#FFFFFF\"><center><table border=\"0\"
//width=\"500\"><tr><td>";
//print "<p><font face=\"verdana\" size=\"+0\"> <center>You Just Entered This Information nto the
//Database<p><blockquote>";
//print "Name : $firstname <p>Lastname:$lastname<p>Address :$address <p>Country:$country<p>Phone:$phone<p>Email:$email </blockquote></td></tr></table>
//</center></BODY>";
// create SQL statement
$sql = "SELECT firstname, lastname, address, country, phone, email FROM prosper
ORDER BY firstname";
// execute SQL query and get result
$sql_result = mysql_query($sql);
// start results formatting
echo "<TABLE BORDER=1>";
echo "<TR><TH>First Name</TH><TH>Last Name</TH><TH>Address</TH><TH>Country</TH><TH>Phone</TH><TH>Email Address</TH>";
// format results by row
while ($row = mysql_fetch_array($sql_result)) {
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$address = $row["address"];
$country = $row["country"];
$phone = $row["phone"];
$email = $row["email"];
echo "<TR><TD>$firstname</TD><TD>$lastname</TD><TD>$address</TD><TD>$country</TD><TD>$phone</TD><TD>$email</TD></TR>";
}
echo "</TABLE>";
// free resources and close connection
mysql_free_result($sql_result);
//mysql_close($connection);
?>
