title: Bind Results from a Left Join using mysqli
body: <p>I'm recently changing to mysqli and while performing an update on a script, i couldn't manage to use the same SELECT information as i did before. How can I bind_results from a Left Join between 3 tables?</p>
  
  <p>This is the script:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT actor.id, actor.name, actor.gender, 
         thumbs.id, thumbs.filename, thumbs.actorid
  FROM actors, thumbs
  LEFT JOIN join_thumbscategory
  ON thumbs.id=join_thumbscategory.thumbsid
  WHERE join_thumbscategory.categoryid='$id_category'
  AND thumbs.actorid=actor.id
  ORDER BY actor.name ASC
  </code></pre>
  
  <p>How can I join 3 tables and bind the results? I'm trying to use msqli prepared statements.</p>