pixelz

How would I implement this?

Hey, TL:DR: The goal I want to achieve is getting statuses from a user's friends w/ an array of friends.. Things already set up: Table for statuses - id(an incremental thing to count), osid(what post, to allow comments), author, user_id(the author's id), type[a,b] (a is a post, b is a comment) and postdate. Table for friends - id(incremental), user1(person that initiated the friendship), user1_id(that person's id), user2(person that accepts the friendship), user2_id(his id), datemade What needs to happen is create an array of all a user's friends pseudo code: "Select user2_id where user1_id is logged_in_user_id" "friends[] = loop(mysql query until no more)" "loop:Select statuses where user_id is friends" "Populate my screen with statuses" I know this is bad pseudo code but please help me put together a working system!