Loop for array created by comma separated values in mysql query fetching first result only

Question

I have saved some values as comma separated in table 1 column.

I want to fetch all rows containing values from table 2 where these comma separated values are.

But my current code is fetching only one row with first value.

Tables structure is like below :

Table 1

id   |  faculties           | another_field
1    |  DFGHFGD1,ERTGDFGE2  | xyzxyzxyz

Table 2

id   |  unique_id   | full_name
1    |  DFGHFGD1    | AAA AAA
2    |  THOGHFGD1   | BBB BBB
3    |  ERTGDFGE2   | CCC CCC
4    |  LLMNBHUH1   | DDD DDD
5    |  HGFGDHHD3   | EEE EEE
6    |  RGDJHFGN4   | FFF FFF
7    |  PLYHTGGD1   | HHH HHH

Now I want to fetch both rows with unique_id = DFGHFGD1 And ERTGDFGE2 in Table 2.

I tried following code. But it is fetching only first value(DFGHFGD1) row.

 <?php 
        $faculty ="DFGHFGD1,ERTGDFGE2"; // Fetch with another query for table 1
        $var = explode(",", $faculty );
        ?>
          <ol>
           <?php
             foreach($var as  $value){
             $fquery = "select * from table_2 where unique_id = '$value'";          
             $result = $database->get_results($fquery);
                foreach($result as $data){
            ?> 
                <li><?php echo $data['full_name'];?></li>
            <?php }  ?>
          </ol>
  <?php } ?>

Result should be like

1. AAA AAA
2. CCC CCC

But I am Getting only

1. AAA AAA

Answer 1

<ol> Tag will be outside of first foreach loop.

Correct code will be :

<?php 
$faculty ="DFGHFGD1,ERTGDFGE2";
$var = explode(",", $faculty);
?>
<ol>
<?php
foreach($var as $value) {
  $fquery = "select * from `table_2` where `unique_id` = '$value'"; 
  $result = $database->get_results($fquery);
  foreach($result as $data){ ?>
    <li><?php echo $data['full_name']; ?></li>
  <?php 
  } 
}
?></ol>