title: How can I retrieve data from a table and using a foreign key retrieve data from another table?
body: <p>I have 2 tables : movies, schedule .</p>
  
  <pre><code>Schedule : schedule_id, movie_id, start_date, start_time ;
  
  Movies: movie_id, movie_name, movie_description ;
  </code></pre>
  
  <p>I'm using php , and I want to retrieve every record in schedule <code>where start_date = 2014-11-14</code> which is quite simple but in the same query I want to get <code>movie_name</code> for every <code>movie_id</code> in schedule .</p>
  
  <p>And if it's possible how will I access the result? </p>
  
  <p>I used this before: <code>while($row = $rs-&gt;fetch_row())</code> but since I want data from 2 tables how will I access it?</p>