Hi firends, hope you all dn well. Here i need one thing !
table1 - Which stores all user's posts
( `id`, `post`, `who` )
table2 - Which stores relations
( `id`, `from`, `to`, `status` ) ( `status` contains `accepted` and `hold` )
here i want to retreve the posts of a friend's friends where
status = 'accepted'. I want in on single line mysql_query is it possible ?
my Query would be like this.
mysql_query("SELECT `post` FROM `table1` WHERE SELECT FROM `table2` `from` OR `to` AND `status` = 'accepted'');
like in a user profile user's friend posts only should be show.