title: Join tables using foreign key
body: <p>I am getting the institutes within 10km in $result. But I want to get the institutes with course name having GATE. How can I do this?
  course_records has a foreign key institute_id in institutes. I am not able to join these tables.
  Any kind of help will be appreciated.</p>
  
  <pre><code> $result=$conn-&gt;query("SELECT *, ( 6371 * acos( cos( radians($user_latitude) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($user_longitude) ) + sin( radians($user_latitude) ) * sin( radians( latitude ) ) ) ) AS distance FROM institutes  HAVING distance &lt; 10 ORDER BY distance  LIMIT 0 , 10 ");
  </code></pre>
  
  <p>mysql> select * from  institutes;</p>
  
  <pre><code>+--------------+-------------------+---------------------+----------------+----------------------------------+-------------+--------+----------+-----------+
  | institute_id | name              | email               | contact_number | address                          | telephone   | tut_id | latitude | longitude |
  +--------------+-------------------+---------------------+----------------+----------------------------------+-------------+--------+----------+-----------+
  |           23 | Dhananjay Classes | dhananjay@gmail.com | 9999888877     | Palam dabri Road,Mahavir Enclave | 011-1234567 |     11 |  28.5892 |   77.0858 |
  |           24 | ffe               | rr@rere             | 323232         |                                  |             |     11 |  28.5667 |   77.2833 |
  +--------------+-------------------+---------------------+----------------+----------------------------------+-------------+--------+----------+-----------+
  </code></pre>
  
  <p>mysql> select * from course_records;</p>
  
  <pre><code>+-----------+------+--------------+-------+--------------+--------------------------+--------------------+---------------+-----------+---------+--------------+
  | course_id | name | subject      | fees  | num_students | num_students_per_teacher | month_of_admission | num_of_trials | commision | created | institute_id |
  +-----------+------+--------------+-------+--------------+--------------------------+--------------------+---------------+-----------+---------+--------------+
  |         1 | GATE | CSE          | 10000 | 110          | 20                       | January            | 3             | yes       | NULL    |           23 |
  |         2 | NDA  | all_subjects | 7000  | 50           | 20                       | April              | 3             | yes       | NULL    |           23 |
  |         3 | 12th | Math         | 2     | 90           | 20                       |                    | 2             |           | NULL    |           23 |
  +-----------+------+--------------+-------+--------------+--------------------------+--------------------+---------------+-----------+---------+--------------+
  </code></pre>