how to contact two tables in a database ?

[Glenskie]

ok i have a script that displays posts , but i want it to only display posts by that person , $id and there friends

here is the code for all of the posts , how would i add it in there to where it gets there friends posts to ? the table for friends is MyMembers and the column is Friend array

$query = mysql_query("SELECT id,to_id,from_id,post,type,state,date FROM posts WHERE state='0' ORDER BY id DESC LIMIT 50");	

there friends are set up as an array

[fenway]

There is no array type column.