Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id firstname lastname email avatar
- 1 Coman Paul x@y.com ./images/a.png
- id user1 user2
- 1 1 2
- 2 1 5
- 3 3 1
- 4 2 3
- select u.firstname, u.lastname,u.email,u.avatar from users u
- inner join friendships f on f.user2 = u.id
- where f.user1 = 1
- union
- select u.firstname, u.lastname,u.email,u.avatar from users u
- inner join friendships f on f.user1 = u.id
- where f.user2 = 1
- if($numrows!=0)
- {
- Echo '<div id="members"> <ul >';
- while ($row = mysql_fetch_assoc($querym))
- {
- $firstname = $row['firstname'];
- $lastname = $row['lastname'];
- $email = $row['email'];
- $avatar = $row['avatar'];
- Echo '<li>......';
- //printing the variables and all data
- }
- }
- select u.firstname, u.lastname,u.email,u.avatar from users u
- where id not in (select user1 from friendships where user2 = 1)
- and id not in (select user2 from friendships where user1 = 1)
- and id <> 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement