Assistance needed with mysql query to achieve this php5

Hi all I have a table below CREATE TABLE friends ( id int(11) NOT NULL auto_increment, member_id int(11) NOT NULL, member varchar(32) NOT NULL, friendwith varchar(32) NOT NULL, friendWithId int(11) NOT NULL, status varchar(32) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ; I run the following query to get my friends SELECT fc.friendWithId, fc.friendWith, uu.image_path, uu.first_name, uu.last_name, uu.city, uu.gender, uu.relationship_status, uu.last_login FROM friends fc JOIN users uu ON fc.friendWithId = uu.user_id WHERE member_id = '%s' AND member = '%s' and fc.status='active' I need help on how to modify the sql query so that it not only displays people who am friends with but should also display people who are friends with me What i currently have is a one way relationship, I am trying to modify the query to create a two way relationship. Cheers --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.