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
Post a Comment