title: php mysql + create a friend request system
body: <p>i am creating a friend request system that allow user to send request to each other to add  as friends like facebook 
   and i have 2 conditions that if :</p>
  
  <ul>
  <li>the user is the profile owner he can not add him self i will echo an
  error msg</li>
  <li>the user is not the owner of the profile it will echo a message that
  say wait then the request is send</li>
  </ul>
  
  <p>if the user has already send the request i will echo a message to infor the user that a request had been send.</p>
  
  <p>but the error is that i am  in the first condition because the system display that the user is the owner profile but this is wrong </p>
  
  <p>can anyone help me ??</p>
  
  <h1>this is a chunk of code</h1>
  
  <pre><code>function addAsFriend(a,b){
     //alert("Member with id:" + a + "request friendship with the memeber with id:" + b);
    var url = "script_for_profile/request_as_friend.php";
    $("#add_friend").text("please wait...").show();
    $.post(url,{request:"requestFreindship",mem1:a,mem2:b},function(data){
      $("#add_friend").html(data).show().fadeOut(12000);
    });
  }
  
  &lt;div class="interactContainers" id="add_friend"&gt;
                 &lt;div align="right"&gt;&lt;a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('add_friend');"&gt;Cancel&lt;/a&gt;&lt;/div&gt;
                 Add &lt;?php echo $username ?&gt; as Friend?&amp;nbsp;
                 &lt;a href ="#" onclick="return false" onmousedown="javascript:addAsFriend(&lt;?php echo $_SESSION['user_id']; ?&gt;,&lt;?php echo $userid; ?&gt;);"&gt;Yes&lt;/a&gt;
  </code></pre>
  
  <h1>  request_as_friend.php</h1>
  
  <pre><code>&lt;?php
  //var we need for  both  members
  $mem1=preg_replace('#[^0-9]#i','',$_POST['mem1']);
  $mem2=preg_replace('#[^0-9]#i','',$_POST['mem2']);
  
  if(!$mem1||!$mem2)
  {
      echo "Error .missing data";
      exit();
  }
  if($mem1==$mem2)
  {
      echo "Error you can not add yourself as friend";
      exit();
  }
   require_once('../include/connect.php'); 
  
  
   if($_POST['request']=="requestFriendship")
   {
       //check that  there  is not  a request  pending  where this viewer  is requesting  this profile  owner
       $sql = mysql_query("SELECT id  FROM friend_requests WHERE mem1='$mem1' AND mem2='$mem2'limit1")or die(mysql_error());
       $numRows = mysql_num_rows($sql);
       if($numRows &gt; 0)
       {
           echo "You have a friend request pending already  for this member. they must approve  it when they view their request list";
           exit();
       }
        //check that  there  is not  a request  pending  where this profile owner  is not already requesting  this viewer
       $sql = mysql_query("SELECT id  FROM friend_requests WHERE mem1='$mem2' AND mem2='$mem1'limit1")or die(mysql_error());
       $numRows = mysql_num_rows($sql);
       if($numRows &gt; 0)
       {
           echo "This user has requested you as friend already! Check  your friend  Request on your profile";
           exit();
       }
       $sql = mysql_query("INSERT INTO friend_requests(mem1,mem2,timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("friend request  insertionn error"));
       //$sql = mysql_query("INSERT INTO pms(to,from,time,sub,msg) VALUES('$mem2','XXXXX',now(),'New Friend Request','YOU Have a New  friend request waiting for approval.&lt;br /&gt;&lt;br /&gt;Navigate to your profile and check  your friend request.&lt;br /&gt;&lt;br /&gt;Thank you.')") or die (mysql_error("friend request PM insertionn error"));
  
    echo "Friend Request  sent  succesfully. this member must approve the request";
    exit();    
   }
  ?&gt;
  </code></pre>