I have a database:
id | tableid | timein | itemdesc | qty
01 | 13 | 11:00 | apples | 4
02 | 13 | 11:00 | bread | 1
03 | 13 | 11:00 | chips | 40
01 | 8 | 17:00 | coffee| 1
02 | 8 | 17:00 | rocket| 1
03 | 8 | 17:00 | snickers | 180
$getsql = "SELECT * FROM 2dopuzzler ORDER BY tableid";
$itsresult = $conn->query($getsql);
// Good one...
$current_cat = null;
while($row = $itsresult->fetch_assoc()) {
if ($row["tableid"] != $current_cat) {
$current_cat = $row["tableid"]; // Table Number
$timein = $row["timein"]; // Placing Order Time
// PRINT THE ORDER CARD
echo "<div class='col s12 m6 l3'>";
echo "<div class='card'>";
echo "<div class='card-content '>";
echo "<div class='row'>";
echo "<div class='col s12 m4 l4 card-wtime'> <i class='tiny material-icons'>add</i><span class='card-wtimetext'>$timein</span> </div>";
echo "<div class='col s12 m4 l4'> <a class=' card-nday waves-effect waves-light red'> <span class='card-ndaytext'>$current_cat</span> </a></div>";
echo "<div class='col s12 m4 l4 card-alldone-btn'> <i class='medium material-icons'>check</i> </div>";
echo "</div>";
echo "<div class='row'>";
}
echo "<div class='card-line'>";
echo " -- ". $row["itemdesc"]." <span class='card-line-q'> ". $row["qty"] . "</span>";
while (i get lines from db) {
if ($row["tableid"] != $current_cat) {
// here open divs
}
// here it cycles through db lines adding to card header text
// (!) here I need closed divs witch adding NOT at an end of each db line
// BUT when $current_cat is changing!
}
//here over all endig divs...
<div class="col s12 m6 l3">
<!-- Card 1 -->
<div class="card">
<div class="card-content ">
<div class="row">
<div class="col s12 m4 l4 card-wtime"> <i class="tiny material-icons">add</i><span class="card-wtimetext ">13:00</span> </div>
<div class="col s12 m4 l4"> <a class=" card-nday waves-effect waves-light red"> <span class="card-ndaytext">13</span> </a></div>
<div class="col s12 m4 l4 card-alldone-btn"> <i class="medium material-icons">check</i> </div>
</div>
<div class="row">
<div class="card-line">
Here goes the header of an info card
<span class="card-line-q"> Here goes the sub-header of an info card</span>
</div>
(!) Here goes cycled information from database. Like that $NAME ; $quantity
// echo " -- ". $row["itemdesc"]." <span class='card-line-q'> ". $row["qty"] . "</span>";
</div>
</div>
<div class="card-action">
// here an appendix of an info card
</div>
</div>
</div>
The problem is that you're not ending the DIVs from the previous category when you start a new category. So each category is nested inside the previous one.
$getsql = "SELECT * FROM 2dopuzzler ORDER BY tableid";
$itsresult = $conn->query($getsql);
// Good one...
$current_cat = null;
while($row = $itsresult->fetch_assoc()) {
if ($row["tableid"] != $current_cat) {
if ($current_cat) { // end previous card
echo "</div></div></div></div>";
}
$current_cat = $row["tableid"]; // Table Number
$timein = $row["timein"]; // Placing Order Time
// PRINT THE ORDER CARD
echo "<div class='col s12 m6 l3'>";
echo "<div class='card'>";
echo "<div class='card-content '>";
echo "<div class='row'>";
echo "<div class='col s12 m4 l4 card-wtime'> <i class='tiny material-icons'>add</i><span class='card-wtimetext'>$timein</span> </div>";
echo "<div class='col s12 m4 l4'> <a class=' card-nday waves-effect waves-light red'> <span class='card-ndaytext'>$current_cat</span> </a></div>";
echo "<div class='col s12 m4 l4 card-alldone-btn'> <i class='medium material-icons'>check</i> </div>";
echo "</div>";
echo "<div class='row'>";
}
echo "<div class='card-line'>";
echo " -- ". $row["itemdesc"]." <span class='card-line-q'> ". $row["qty"] . "</span>";
echo "</div>";
}
if ($current_cat) { // end last card
echo "</div></div></div></div>";
}