1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?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>';
}
?>
|