closetable();
opentable('znajomi');
$wynik = dbquery("SELECT tp.*, u.* FROM ".$db_prefix."buddys tp LEFT JOIN ".$db_prefix."users u ON tp.buddy_to =u.user_id
WHERE buddy_from ='$lookup'");
echo "
Lista znajomych:
";
if(dbrows($wynik) > 0) {
while($r = dbarray($wynik)) {
echo "".$r['user_name'].", ";
[color=red]if ($wynik['user_avatar'] != "") {
echo "
";
} else { echo "
"; }[/color]
}
} else {echo "brak znajomych";}