1#@!#!123s

: / home3 / encodto1 / aviscollection.com /
Filename : demo.php
back
<ul class="list-inline">
                                            <li class="mega-menu-col col-lg-12 col-sm-12">
                                                <ul class="row flex-fill">
                                                <?php 
                                                $women_qry = "SELECT * FROM product_category WHERE category_gender = 'female'";
                                                $women_data = mysqli_query($conn, $women_qry);
                                                if($women_data-> num_rows > 0){
                                                while($wom = mysqli_fetch_assoc($women_data)) { 
                                                    $women_cat_id = $wom['category_id'];
                                                ?>
                                                    <li class="mega-menu-col col-lg-3 col-md-4 col-sm-6 col-xs-12 d-flex flex-column">
                                                    <?php echo '<h4><span class="submenu-title">'.$wom['category_name'].'</span></h4>'; ?>
                                                        <ul>
                                                        <?php
                                                        $women_subQry = "SELECT * FROM product_sub_category WHERE product_category = $women_cat_id";
                                                        $sub_data = mysqli_query($conn, $women_subQry);
                                                        if($sub_data-> num_rows > 0){
                                                        while($sub = mysqli_fetch_assoc($sub_data)) { 
                                                        $wear_name = $sub['sub_category_name'];
                                                        ?>
                                                            <li><a class="dropdown-item nav-link nav_item" href=""><?php echo $wear_name; ?></a></li>
                                                        <?php } } ?>
                                                        </ul>
                                                    </li>
                                                    <?php } } ?>
                                                </ul>
                                            </li>
                                            
                                        </ul>