...

View Full Version : Mysql compare data and display the diference



seuntech
03-20-2010, 01:20 PM
i have two tables like the one below i want the table to show what is in table 1 and not in table 2 only. the table value changes always so i can not just write down 1 as the result

id number
1 4
2 4
3 5
4 1
5 5

table 2
id number
1 4
2 4
3 4
4 5
5 5


what i am trying to do is to creat PEOPLE YOU MAY KNOW script like facebook, i have been able to get a user-A friend list, and friends of friend of user-A list as well, so now i want to remove user-A friend list from Friends of friend user-A list so that it does not show me people that are aleady my friend.
for those that does not understand please just solve the question above for me i think i can figure out the rest or if you have already made script, it would be very appreaciated

thank you in advance



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum