/extremedating/trunk

<?PHP

	$userinfo = $db->query("SELECT city from Users WHERE loginName='$username'");

	$self = $userinfo->fetchAll();

	$city = $self [0];

	$finderinfo = $db->query("SELECT loginName from Users WHERE city='$city[0]' AND loginName != '$username'");

	$userlist = $finderinfo->fetchAll();

	foreach ($userlist as $user) {

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

		$self = $userinfo->fetchAll();

		$firstName = $self[0];

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

		$self = $userinfo->fetchAll();

		$surName = $self[0];

		echo '<div class=feedbox >';

		echo '<a href="./profile.php?uid=' . $user[0] . '">' . $firstName[0] . ' ' . $surName[0] . '</a>' . ' bor också i ' . $city[0];

		echo '</div>';

	}

?>