/extremedating/trunk

<img class="profilepic" src="./get_image.php?userName=<?PHP echo $username;?>"/>

<a href="profile.php?uid=<?php echo $username; ?>" class="profilename"><?php echo $firstName . " " . $surName;?></a>

<p class="smallheader">Personer jag vill träffa:</p>

<?PHP

	$relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");

	$relationstring = $relationinfo->fetchAll();

	echo '<UL>';

	foreach ($relationstring as $relationquery) {

		$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");

		$self = $userinfo->fetchAll();

		$firstName = $self [0]['firstName'];

		$userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");

		$self = $userinfo->fetchAll();

		$surName = $self [0]['surName'];

		echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';

	}

	echo '</UL>';

	echo '<p class="smallheader">Personer som vill träffa mig:</p>';

	echo '<UL>';

	$relationinfo = $db->query("SELECT user2 from dateInterests WHERE(user1='$username')");

	$relationstring = $relationinfo->fetchAll();

	foreach ($relationstring as $relationquery) {

		$relation2info = $db->query("SELECT user2 from dateInterests WHERE(user1='$relationquery[0]')");

		$relation2string = $relation2info->fetchAll();

		foreach ($relation2string as $relation2query) {;

			if($relation2query[0] == $username){

				$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$relationquery[0]'");

				$self = $userinfo->fetchAll();

				$firstName = $self [0]['firstName'];

				$userinfo = $db->query("SELECT surName from Users WHERE loginName='$relationquery[0]'");

				$self = $userinfo->fetchAll();

				$surName = $self [0]['surName'];

				echo '<li><a href="./profile.php?uid=' . $relationquery[0] . '">' . $firstName . ' ' . $surName . '</a></li>';

			}

		}

	}

	echo '</UL>';

?>