Need help to filter tecnique for newsfeed

[KFlash32]

Hi

 

Need some help here to figure out how I can filter out something from a newsfeed Im creating. The principle are simple. One query get all the uses friend, and show the feed. Thats okey.

 

Problems starts here. I have created a function now so let the users choose if he / she want to see other friends photos or videos in this feed. All that information are stored in a second MySQL table.

 

What I try to do, is to filter this out, so not the spesific users photo OR video are visible in the stream for the users who does not want to see that kind of stuff.

 

I figured out I cant do that in mysql with a line like this

 

photo_id NOT IN (SELECT PHOTO ID FROM PHOTOS LEFT JOIN FILTER TABLE WHERE PHOTOS_OWNER = FILTER_FRIEND  WHERE FILTER_OWNER = ME AND PHOTO_FRIEND = MY_FRIEND AND PHTOS = 1

 

in that way, it would simple not show that current photo if the ID match the ID in the PHOTO table.

 

But not so easy was it not.

 

So I try to figure out the best way to sort this off.

 

Any help would be preciated.