mysql - How to make a table view in php -

i net sure called want make table dynamic. top named "tier" , values taken database table named "tier". on side there "items" "items" table database. have made intermediate table many many relationship an item have man tiers tier has many items. in intermediate table storing item id , tier id.

i have manged display tiers , items dynamically according database, im not sure how fill data now.

what want take values intermidate table , insert it. value boolean either true or false. example want check if silver tier has photo, if equals true want display it. how can such thing because cant wrap head around it.

here code did generate table, if there improvement can make please tell me want learn code better if possible.

<table>     <tr>         <td></td>         <?php         $counter = 0;         //to show of tiers         foreach ($tier $tier) {             $counter ++;             ?>             <td>                 <?php echo $tier->name; ?>             </td>             <?php             foreach ($itemtier $value) {                 if($tier->id == $value->itemid){                     echo $value->value;                 }             }             ?>         <?php         }         ?>     </tr>     <?php     //showing of options     foreach ($item $item) {         ?>         <tr>             <td>                 <?php echo $item->name; ?>             </td>             <?php             //displaying columns             for($i = 0; $i< $counter; $i++){                 ?>                 <td>                 </td>             <?php             }             ?>         </tr>     <?php     }     ?> </table> 

<?php $variable = 'hello world'; ?> <table>  <tr>   <td>    <? echo $variable; ?>   </td>  </tr> </table>