By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

filtering messenger friend list for invite

omerbutt
100+
P: 638
hi there i am making a social community site in which i have to invite the messenger contacts by entering the user pass, i have done it right till grabbing the contacts but what i have to do now is to filter those addresss which already have an account on that site means i have two databases one that has the member emails of the site and other one that grabs the contacts of the user and puts it into
the datbase.now i am trying to compare these two databases that the contacts of the user that are already in the members database should not be invited. ihave used this query but itsnot working can anybody help in this regard
Expand|Select|Wrap|Line Numbers
  1.     $sqlEP="select hotmail_email,member_email from hotmail_contacts,rage_members where (hotmail_contacts.hotmail_email<>rage_members.member_email)";
  2.      $rsEP=mysql_query($sqlEP) or die(mysql_error().'<br />'.$sqlEP);
  3.  
  4.  
Apr 18 '08 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
You need to pass ids from the first and pass the same to the second and use count to find out if that already exists.
Apr 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.