PHP: Group data without using 'group_by'

Question

PHP: Group data without using 'group_by'

Navigation

#1 by (0 votes)

0

Does anyone know how to group data without using group_by in the query?

I need every 10

results

to create a div , that is, 10 records within each div I do not care about values.

<?php foreach($resultados->result() as $resultado){ ?>
    <?php for($i = 0; $i <= 10; ++$i){ ?>
        <div>
    <?php } ?>
        <?=$resultado->id?>
    <?php for($i = 0; $i <= 10; ++$i){ ?>
        </div>
    <?php } ?>
<?php }// foreach ?>

php loop query foreach for

asked by anonymous 22.07.2018 / 03:50

1 answer

Problem in creating foreign keys MySQL Ion-select does not work as it should

score 0 · Answer 1

One way to do this would be to use an auxiliary counter ( $c ) and module ( %) .

Example:

$c = 0;
foreach($resultados->result() as $resultado){

    if ($c % 10 == 0) echo  '<div>';
    echo $resultado->id;
    if ($c % 10 == 0) echo  '</div>';

    $c++;
}