using mysql inner join with three tables, cannot display result in php output -


i joining 3 tables, prefixed each column name table each column name distinct. query gives me result want in mysql when attempt echo out specific field name in php, won't display. have tried both mysqli_fetch_arrary() , mysqli_fetch_assoc().

<?php $query  = "select * "; $query .= "from plans "; $query .= "inner join plans_items on plans.plan_id = plans_items.fk_plan_id  "; $query .= "inner join items on plans_items.fk_item_id = items.item_id ";                     $item_set = mysqli_query($connection, $query);                     confirm_query($item_set); ?> <ul class="pages"> <?php      while($single_item = mysqli_fetch_array($item_set)) { ?>     <li><?php echo "name :" .$row['item_name']. "."; ?></li> <?php     } ?> <?php mysqli_free_result($item_set); ?> </ul> 


Comments