I'm having a conflict in the while

0

I'm having a confection in my while where I have a table of categories and the category ej has 10 categories.

The problem arises when throwing the id to review since it is thrown to me 2 onwards:

<?php 
    mysqli_select_db($conexion, $database_conexion);
    $query_DatosCategorias = sprintf("SELECT * FROM categorias");
    $DatosCategorias= mysqli_query($conexion, $query_DatosCategorias) or die(mysqli_error());
    $row_DatosCategorias = mysqli_fetch_assoc($DatosCategorias);
    $totalRows_DatosCategorias = mysqli_num_rows($DatosCategorias);

    $total = $totalRows_DatosCategorias;
    $limite = $total/2;
    $listas = null;
    $inicio = 1;
    $k = null;
    $listas = $total/$limite;
    $cantidadListas = ceil($listas);
    ?>
    <footer class="site-footer footer-light" style="background-image: url(<?php echo $urlWeb;?>/img/footer-bg-alt.png);">
        <div class="container">
            <div class="row">
                <div class="col-lg-6">
                    <!-- categorias-->
                        <section class="widget widget-links">
                            <h3 class="widget-title">Categorias</h3>
                                <div class="row">
                                    <?php
                                        for ($i=$inicio; $i <=$cantidadListas; $i++) { 
                                            for ($j=1; $j <=$limite && $k<$total; $j++) { 
                                                $k = $k+1;
                                                $i=0;
                                                while ($row_DatosCategorias = mysqli_fetch_assoc($DatosCategorias)) {
                                                    $i++;
                                                    if ($i==1) {
                                                        echo "<div class='col-md-6'>";
                                                        echo "<ul>";
                                                    } // primera lista
                                                    echo '<li>'.$row_DatosCategorias['id'].'</li>';
                                                    if($i % $limite == 0 || $i == $total) { 
                                                        echo "</ul></div>"; // cerrar lista
                                                        // Si quedan más elementos abrir otra
                                                        if ($i < $total) {
                                                            echo "<ul>";
                                                        }
                                                    }
                                                } //end while
                                            }
                                        }
                                    ?>
    
asked by Matias 30.06.2018 в 21:39
source

0 answers