Menu
Community /Pin to ProfileBookmark
@NogDogApr 23.2019 — #Not sure why you need/want the foreach loop inside of the while loop? Not sure if that's the problem, though, or if it's at the SQL level. If, before the loop, you do a mysql_fetch_all() and print_r() or var_export() the result, does it have multiple rows like what you're seeing output? I.e., something like
@NogDogApr 23.2019 — #PS: If you wrap your code blocks in
normal array or 2 dimensional array?
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
Sign in
to post a comment12 Comments(s) ↴
0
@NogDogApr 23.2019 — #Not sure why you need/want the foreach loop inside of the while loop? Not sure if that's the problem, though, or if it's at the SQL level. If, before the loop, you do a mysql_fetch_all() and print_r() or var_export() the result, does it have multiple rows like what you're seeing output? I.e., something like<i>
</i>if ($runSql_qry1_1) {
$data = mysqli_fetch_all($runSql_qry1_1, MYSQLI_ASSOC);
echo("<pre>DEBUG:n".print_r($data, 1)."</pre>");
// or write to the php log via error_log(), if you prefer
0
@NogDogApr 23.2019 — #PS: If you wrap your code blocks in ...0
@NogDogApr 24.2019 — #Probably because of the way it's joining, I suspect. Maybe the easy solution would be to do a SELECT DISTINCT ...0
@NogDogApr 24.2019 — #I think it is the foreach, which is looping through each element of the result row, so outputting twice. You should be able to simplify it to:<i>
</i>if ($runSql_qry1_1) {
if (mysqli_num_rows($runSql_qry1_1) > 0) {
while ($resultDishTitle_DishPrice = mysqli_fetch_assoc($runSql_qry1_1)) { ?>
<div class="row">
<div class="col-sm-10">
<?php echo $resultDishTitle_DishPrice['MenuItemTitle']; ?>
</div>
<div class="col-sm-2">
<?php echo $resultDishTitle_DishPrice['MenuItemPrice']; ?>
</div>
</div>
<?php <br/>
}
} <br/>
}