subquery - Need an SQL query with multiple, dynamic "WHERE" condition -

i need query show posts of connected user , friends, in context of social netowork.

users table headers: id, account_name, password, name, birthdate, description

posts table headers: id, user_id, text, date

friends table headers: id_user_1, id_user_2

current query:

select p.id, p.users_id, p.text, p.date, u.id, u.name post p inner join users u on p.users_id = u.id p.users_id = 1 or p.users_id=(    select users_id_2 friends    users_id_1 = 1) order date 

note: current users_id (1) variable inserted via php.

my problem subquery returns multiple rows, namely id of each of connected user's friends.

you close:

select p.id, p.users_id, p.text, p.date, u.id, u.name post p inner join users u on p.users_id = u.id p.users_id = 1     or p.users_id in      (select users_id_2 friends       users_id_1 = 1) order date