title: php mysql select multiple values from one table
body: <p>I'm trying to access a MySQL DB using PHP. I need to retrieve 6 values from my <code>actor_id</code> table displaying them in a html table. My SELECT statement is:</p>
  
  <pre><code>SELECT actor_id.actor_name, FROM actor_id WHERE movie.star1 = actor_id.actor_id;
  </code></pre>
  
  <p>Now how can I add another movie.star2, movie.star3 etc.??</p>
  
  <p>DB Structure</p>
  
  <p>NAME - fields
  movie - movie_id title star1 star2
  actor_id - actor_id actor_name</p>