Friends script,

[ImNotSatan]

Hey guys, im makeing a script but idk what goes wrong

<?php
$query = mysql_query("SELECT receiver FROM messenger_friendships WHERE sender = '".$_SESSION['user']['id']."'");
while ($friends = mysql_fetch_assoc($query)) {
$getfriend = mysql_query("SELECT * FROM users WHERE id ='".$friends['receiver']."' AND online = '1' LIMIT 1");

if (mysql_num_rows($getfriend) > 0) {
$friend = mysql_fetch_assoc($getfriend);

echo "<font color='green'>".$friend['username']."<br/></font>";
}

}
?>

Like, i have the friends:
noobfriend1 and noobfriend2

i want it to just show noobfriend2

I tried this:

$query = mysql_query("SELECT receiver FROM messenger_friendships WHERE sender = '".$_SESSION['user']['id']."' LIMIT 2 OFFSET 1");

also i tried LIMIT 1, when i put limit at it i dont even see noobfriend1, anny solution?!


y, this is r63b so i have the good querys but idk what goes wrong!

[MentaL]

[The General]

Is your other friend only because you also check AND online = '1' ?

[ImNotSatan]

Is your other friend only because you also check AND online = '1' ?

Well, i only want it to show offline friends, and atm i have 3 friends online

More info:
I basicly want somthing like:

Friend1:$usernamefriend1
Friend2:$usernamefriend2
Friend3:$usernamefriend3

i downloaded this cms, i mean this footer with the friedns

http://forum.ragezone.com/f353/habbo...revcms-985195/

[flx5]

Try this:

<?php
$sql = mysql_query("SELECT messenger_friendships.receiver as id, users.username FROM messenger_friendships, users WHERE messenger_friendships.sender = ".$_SESSION['user']['id']." AND users.id = messenger_friendships.receiver AND users.online=1");
while($friend = mysql_fetch_assoc($sql)) {
    echo "<font color='green'>".$friend['username']."<br/></font>"; 
}
?>

If you want to learn more, read about linking tables (better than the above would be to use JOIN)

[The General]

SELECT messenger_friendships.receiver as id, users.username FROM messenger_friendships INNER JOIN users ON messenger_friendships.sender = users.id WHERE messenger_friendships.sender = ".$_SESSION['user']['id']."  AND users.online=1

Something like that will do the trick

[ImNotSatan]

[QUOTE=flx5;7967527]Try this:
[PHP]
<?php
$sql = mysql_query("SELECT messenger_friendships.receiver as id, users.username FROM messenger_friendships, users WHERE messenger_friendships.sender = ".$_SESSION['user']['id']." AND users.id = messenger_friendships.receiver AND users.online=1");
while($friend = mysql_fetch_assoc($sql)) {
echo "<font color='green'>".$friend['username']."<br/></font>";
}
?>

It doesnt work,

<?PHP
$query = mysql_query("SELECT * FROM messenger_friendships WHERE sender = '".$_SESSION['user']['id']."'");
$i = 0;
while ($friends = mysql_fetch_array($query)) {
$getfriend = mysql_query("SELECT * FROM users WHERE id ='".$friends['receiver']."' AND online = '1' LIMIT 1");

if (mysql_num_rows($getfriend) > 0) {
$i++;

if ($i == 1) {
echo '<li id="feed-friends">Friends online:<span> ';
}

$friend = mysql_fetch_array($getfriend);
echo htmlspecialchars($friend['username']).', ';
}

}
?>

this shows it like

friend1, friend2, friend3, friend4, friend5, friend6,

and that script u gave me even show's offline users etc O_O?
whats wrong?