Welcome Guest, Not a member yet? Register   Sign In
AR get own posts and friends posts
#4

[eluser]jprateragg[/eluser]
I'm not familiar enough with AR to put your query in that format, but you could just use a regular SQL query:

Code:
SELECT p.post_title, p.post_date, u.username
FROM posts p
LEFT JOIN users u ON u.id = p.user_id
WHERE p.user_id = 2 OR p.user_id IN (SELECT user_id FROM user_followers WHERE follower_id = 2)

This would probably do what you want it to do.


Messages In This Thread
AR get own posts and friends posts - by El Forum - 11-21-2012, 10:32 AM
AR get own posts and friends posts - by El Forum - 11-21-2012, 10:40 AM
AR get own posts and friends posts - by El Forum - 11-21-2012, 02:48 PM
AR get own posts and friends posts - by El Forum - 11-21-2012, 07:13 PM
AR get own posts and friends posts - by El Forum - 11-22-2012, 01:25 AM
AR get own posts and friends posts - by El Forum - 11-22-2012, 02:07 AM



Theme © iAndrew 2016 - Forum software by © MyBB