title: Making a general search box using php and mysql to search through several tables
body: <p>I have 2 tables namely: <code>tbl_subscriber</code> and <code>tbl_faculty</code>.<br> 
  <code>tbl_subscriber</code> has fields namely:<code>name</code>,<code>id_number</code>,<code>email</code>,<code>phone</code>.<br><br>
  <code>tbl_faculty</code> has :<code>f_name</code>,<code>l_name</code>,<code>email</code>,<code>phone</code>.</p>
  
  <p>I have a search box. I want to write a query that if I type a phone number / email / name / f_name / l_name in it then it should search both the tables to match the supplied entry and it should return all rows corresponding to that entry. </p>
  
  <p>It is for sure that the supplied entry would be in either of the mentioned table (as I have made the tables like that)and not in both. What I mean is at one time only one table fields would match but the query should search both the tables simultaneously.</p>