how to display all coins from mysqli?

[josh_7]

Hey everyone i am just asking for a little bit off help if thats fine
how can i make 11 fetch scripts into 1 script please

database

i like to make this menu to display the coins i know you can do it but i dont know how since am not pro

<ul class="nav nav-pills mb-3" id="pills-tab" role="tablist"> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false">Pick a coin</a> <div class="dropdown-menu"> <a class="dropdown-item" id="pills-btc-tab" href="#pills-btc" role="tab" data-toggle="pill" aria-controls="pills-btc"><img src="https://i.imgur.com/h2bZxBg.png" width="23" height="23"> Bitcoin</a> </div> </ul>

fetch from mysqli i have btc here but i like to get every coins info when it gets added so dispays here from dropdown menu

 <h1><strong><center> coin name here from mysqli : Faucet List</center></strong></h1> <?php
     $query = "SELECT* FROM list WHERE coin_name='BTC'"; 
     //execute the query. 
     if($result = $link->query($query)){          
          echo '<table id="faucetlist" class="table table-bordered table-condensed table-hover" style="width:100%">';
          echo "<thead>";
          echo "<tr>";
          echo "<th><center> Name</center></th>";
          echo "<th><center>Wallet</center></th>";              
          echo "<th><center>Time</center></th>";                
          echo "<th><center>Reward</center></th>";
          echo "<th><center>Claim </center></th>";
          echo "</tr>";                     
          echo "</thead>";
      while($row = $result->fetch_assoc()){
echo "<tr> <td>". $row['faucet_name'] .'
</br><strong>Paying : </strong> <small style="color:' . $row['css'] . '">' . $row['paying'] . '</small> </br><strong>owner : </strong> <small style="color:' . $row['css'] . '">' . $row['owner_name'] . "</small></td>";
                if ($row['wallet'] === "Ewallet") {
echo '<td class="text-center" style="vertical-align: middle;"><span class="btn btn-xs btn-success">' . $row['wallet'] . '</span></td>';  
            } else {
echo '<td class="text-center" style="vertical-align: middle;"><span class="btn btn-xs btn-dark">' . $row['wallet'] . '</span></td>';
            }                
echo '<td class="text-center" style="vertical-align: middle;"><span class="btn btn-xs btn-info"> ' . $row['timer'] . ' Minutes</span></td>';
echo '<td class="text-center" style="vertical-align: middle;"><span class="btn btn-xs btn-warning"></i> ' . $row['max_reward'] . '</span></td>';
echo '<td class="text-center" style="vertical-align: middle;"><a href="' . $row['Website_url'] . $row['ref_address'] .'" target="_blank"><span class="timer btn btn-xs btn-primary">claim <i class="fa fa-external-link" aria-hidden="true"></i></span></a></td>';
echo "</tr>";               
                 }
                  echo "</table>";
                 $result->close();
            }  else {
                 printf("<p>Error: %s</p>\r\n", $mysqli->error);
            }
            ?>