<?
/* This script processes the data passed from profile.php3 */

/* variable declaration */

$mysql_db = "dubhlinn";
$mysql_user = "dubhlinn";
$mysql_pass = "c3ae7rw";
$mysql_host = "";
$table=blkdir;

/* Make connection to the database */
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or DIE("Unable to connect to database");
@mysql_select_db($mysql_db) or DIE("Unable to select database");

$query = "select * from $table where Last_Name like '$Last_Name'";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
while($row = mysql_fetch_array($result)) {
	$First_Name=$row["First_Name"];
	$Last_Name=$row["Last_Name"];
	$SCA_Name=$row["SCA_Name"];
	$Awards=$row["Awards"];
	$Street1=$row["Street1"];
	$Street2=$row["Street2"];
	$City=$row["City"];
	$State=$row["State"];
	$Zip=$row["Zip"];
	$Home=$row["Home"];
	$Work=$row["Work"];
	$Cell=$row["Cell"];
	$CPbutton=$row["CPbutton"];
	$Eprime=$row["Eprime"];
	$Esec=$row["Esec"];
	$Eter=$row["Eter"];
	$URL=$row["URL"];
	$Heraldry=$row["Heraldry"];
	$Comments=$row["Comments"];
	$ModDate=$row["ModDate"];
	$ID=$row["ID"];
	print "$row[0] $row[1] found in database<br>";
	print "ID number $row[20]<p>";
}

print "result: $result <p>";
print "This is a test<p>";
Print "If this had been a real....<P>";
PRINT "$query<p>";
print "number: $number <p>";

mysql_close();
?>
