Nsryjdtyk

My JOIN below - 3 tables - Database structure straight forward . problem table #3 comment_id = primary AI, company_id indexed (used for join), other fields non indexed. Core problem = rows with same ID.

$stmt_E = $db2->prepare("

SELECT c.company_id

     , c.company_name

     , c.company_status

     , c.effective_date

     , c.ckby

     , c.time

     , e.ck1

     , e.ckby1

     , e.time1

     , e.ck2

     , e.ckby2

     , e.time2

     , e.ck3

     , e.ckby3

     , e.time3

     , e.ck4

     , e.ckby4

     , e.time4

     , e.ck5

     , e.ckby5

     , e.time5

     , e.ck6

     , e.ckby6

     , e.time6

     , e.ck7

     , e.ckby7

     , e.time7

     , e.ck8

     , e.ckby8

     , e.time8

     , e.ck9

     , e.ckby9

     , e.time9

     , e.ck10

     , e.ckby10

     , e.time10

     , cc.company_id

     , cc.active_comment

     , cc.active_comment_sentby

     , cc.active_comment_time

  FROM companies c

  JOIN enrolled_checklist e 

    ON e.company_id = c.company_id

  JOIN active_comments cc 

    ON cc.company_id = c.company_id 

 WHERE company_status = 'E'  

 ORDER 

    BY company_name asc  

    ");

$stmt_E->bind_result($company_id, $company_name,$company_status,$effective_date,$ckby,$time,$eck1,$eckby1,$etime1,$eck2,$eckby2,$etime2,$eck3,$eckby3,$etime3,

                                  $eck4,$eckby4,$etime4,$eck5,$eckby5,$etime5,$eck6,$eckby6,$etime6,$eck7,$eckby7,$etime7,$eck8,$eckby8,$etime8,

                                  $eck9,$eckby9,$etime9,$eck10,$eckby10,$etime10,$cccompany_id,$active_comment,$active_comment_sentby,$active_comment_time );

$stmt_E->execute();

$stmt_E->store_result();

My Loop - echo HTML - THIS SECTION gets duplicated by the same number of comments in 3rd table rather than the actual comments populating in desired section

while ($stmt_E->fetch()){



echo"        

              $tr 

                <td width='25%'> etc...............

I use 2 table info for checklist --- works perfect

When I try to place comment, matched to corresponding company, problems begin.

<div class='col-xs-12 cl-sm-12 col-md-12 col-lg-12'>

   <input type='textarea' name='active_comment' value='$active_comment -$cccompany_id' placeholder='' readonly>

</div>  



 ";

}

?>

I simply need all Comments from 3rd table to populate without duplicating all other fields. there could be as many as 25 Comments to one company ID. I need them to display within each company's section.