Query used retrieves two column’s values menuItem and the price
`$querySubCatDishTitlePrice = “SELECT MenuItemTitle, MenuItemPrice FROM MenuItem INNER JOIN SubCategory ON FK_SubCategoryId = PK_SubCategoryId WHERE SubCategoryTitle = ‘Dosai'”;
from this for each row I need create a new bootstrap row with two columns one holding the item title/ dish name and the other holding the price.
`<div class=”row”>
<div class=”col-*-*”> <?php echo $title; ?> </div>
</div>
<div class=”row”>
<div class=”col-*-*”> <?php echo $price; ?></div>
</div>
I’m not too sure but idea I have is create a two dimensional array from mysqli_fetch_assoc, the first dimension holding the title and the second holding the price. Am I right to presume this? or is there a better way of doing this?
Ideas, solutions, pointers appreciated