title: Search a mysql table through another table
body: <p>I would really appreciate it if you can just give me a way or an idea on how to solve my problem:</p>
  
  <p>I have a table that contains my users information like name,email.....etc. And the row's id like 1,2,3 (auto increment).</p>
  
  <p>And another table that checks if the first member is a second member friend, it goes like : mem1 id, mem2 id, date added, row's id...etc</p>
  
  <p>And what I want to make a regular HTML form, that let's he user searches for his friends. Like if jack types the name of his friend John, he gets whether John is his friend or not according to the second table. </p>
  
  <p>I would be really joyful if someone can help me, I'd really be happy..</p>