Bind Results from a Left Join using mysqli

Question

Hi, 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?

This is the script:

"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";

Thanks in advance!

Thanks for the reply! Ok, so the code might be confusing... let´s start from scratch!

How can i join 3 tables and bind the results? I'm trying to use msqli prepared statements.

Thanks again!