query("SELECT user2 from dateInterests WHERE(user1='$username')");
$relationstring = $relationinfo->fetchAll();
echo '';
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 '- ' . $firstName . ' ' . $surName . '
';
}
echo '
';
echo '';
echo '';
$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 '- ' . $firstName . ' ' . $surName . '
';
}
}
}
echo '
';
?>