title: I can not extract results using join table
body: <p>I have 2 tables </p>
  
  <p>first table Actors it has </p>
  
  <pre><code> ID      name_english           picture               link
   5       Daniela Bessia         4f8ab755ed.png        daniela-bessia
   6       Mohannad Alarjan       14f8dfsf55ed.png      mohannad-alarjan
   7       Lee Tae-Im             kxe3gj64.jpg          lee-tae-im
  </code></pre>
  
  <p>second table actors_content</p>
  
  <pre><code>id       content_id      actors_id
  1        7               5
  2        5               5
  3        5               6
  4        5               7
  
  </code></pre>
  
  <p>Now my query is request by drama id if the visitors visit drama id number 7 ( content_id ) it should coming search on second table actors_content and select all data has content_id = 7 after select i want to make join one by one to make while for actors data without duplicate to get actors details from Actors </p>
  
  <pre><code>public function dodisplayActorsbycontent($getid){
  $query = $this-&gt;db-&gt;query("SELECT `actors`.`id` , `actors`.`name_english` , `actors`.`picture` , `actors`.`link` , `actors_content`.* FROM `actors_content`, `actors` WHERE `actors_content`.`content_id` = '".$getid."'");
  $total = $this-&gt;db-&gt;resultcount($query);
  if($total != 0){
  while($this-&gt;db-&gt;fetchrow($query)){
  $list[] = $this-&gt;db-&gt;_record;
  }
  return($list);
  }else{
  return(false);
  }
  }
  </code></pre>