php / mysql数组或带有一些值的查询

Question

Hello I have this query

$upit = "SELECT id from usluga";
$rezultat = mysql_query($upit);
while($red = mysql_fetch_object($rezultat))
{
    echo "<li>{$red->id}</li>";
}

I want on exit to get this:

<li>1,2,3,4,5,6</li>
<li>7,8,9,10,11,12</li>
<li>13,14,15,16,17,18</li>
<li>19,20,21,22,23,24</li>

and so on..

Any help?

Answer 1

You can use the mod operator(%) or use array functions to achive this

$upit = "SELECT id from usluga";
$rezultat = mysql_query($upit);

while ($red=mysql_fetch_object ($rezultat)) {
    $t[] = $red->id;
}

$chunks = array_chunk($t, 6);
foreach ($chunks as $chunk) {
    echo "<li>" . join(",", $chunk) . "</li>";
}