<html><head></head><body>

<h1 align="center">
List of People Who Signed Up
</h1>

<?
// Viewing part
@$db = mysql_connect('localhost','db_username','db_password') or die("Can't connect");
@mysql_select_db('sp07') or die("Can't select a database");
$q = "select name,email,homepage,date,ip from List";
$r = @mysql_query($q) or die("Can't perform query");

while ($row = mysql_fetch_array($r))
{
	$name = ucwords(strtolower(trim($row['name'])));
	if (!empty($name))
		echo "<b>Name:</b> ", $name, "<br />\n";
	$date = trim($row['date']);
	if (!empty($date))
		echo "<b>Date:</b> $date<br />\n";
	$email = trim($row['email']);
        if (!empty($email))
		echo "<b>Email:</b> <a href='mailto:$email'>$email</a> <br />\n";
	$homepage = trim($row['homepage']);
        if (!empty($homepage))
		echo "<b>Homepage:</b> <a href='$homepage'>$homepage</a> <br />\n";
	echo "<hr />\n";
}


@mysql_close($d);

?>

<center><a href="A71.php">Sign up</a></center>

</body>
</html>



