Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $joined = "(SELECT (IF (GU.uid_fk = '$uid',1,0)) as joined ) LIMIT $offset, $limit";//because this says so, at the end this query is the same as in follow friend,
- $sql = "SELECT G.uid_fk,G.group_id, G.group_name, G.group_created, U.username, U.profile_pic,U.bio, G.group_desc, G.group_pic, U.group_count ";
- $sql .= " FROM groups G, users U ";
- $sql .= "JOIN group_users GU ";
- $sql .= "WHERE U.status = '1' IN ";
- $sql .= $joined;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement