PHP while loop

sveiki

bandau padaryti headerio categorijas su sub_categorijom, kazkas kertasi antrajame WHILE loope

          <?php

                $query = "SELECT * FROM header_cat";
                $select_all_categories_query = mysqli_query($connection, $query);

                while ($row = mysqli_fetch_assoc($select_all_categories_query)) {
                    $header_title = $row['header_title'];
                    $header_id = $row['header_id'];
                    $header_url = $row['header_url'];
                    $header_dropdown = $row['dropdown'];

                    if ($header_dropdown == 0) {
                        echo "<li class='nav-item'><a class='nav-link' href='{$header_url}'>{$header_title}</a></li>";
                    } else {

                        ?>

                        <li class="nav-item dropdown">

                            <a class="nav-link dropdown-toggle" href="#" role="button" data-bs-toggle="dropdown"
                               aria-expanded="false">
                                <?php echo $header_title ?>
                            </a>
                            <ul class="dropdown-menu">

                                <?php

                                $query = "SELECT * FROM categories WHERE header_id =$header_id";
                                $select_all_categories_query = mysqli_query($connection, $query);

                                while ($row = mysqli_fetch_assoc($select_all_categories_query)) {
                                    $category_title = $row['cat_title'];
                                    $category_id = $row['cat_id'];


                                    echo "<li><a class='dropdown-item' href='category.php?category={$category_id}'>{$category_title}</a></li>";

                                }
                                ?>

                            </ul>
                        </li>


                        <?php
                    }
                }
                ?>

Ok, tai tu ikelsi cia PHP error log'a ar lauksi kol zmones cia isikels tavo koda pas save?

Pirmo while viduj dar kartą setini $row variable?

while ($row2 = mysqli_fetch_assoc($select_all_categories_query)) {
                                    $category_title = $row2['cat_title'];
                                    $category_id = $row2['cat_id'];

prieš 9 valandas, MatasR parašė:

thanks,i was 2 times using same name of variable