每10个结果后的新列

Question

I am getting result as...............

Column 1

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

.

.

So On

I need to display result like this ...... new column after every 10 rows.

col 1  |    col 2  | .....
abc    |    11     | 21
jjj    |    12     |  .
jhjjk  |    13     |  .
jhbjj  |    ...    |  .
.....  |    ...    |  .  
.....  |    ...    |  .
10     |    20     | 30

have done this much .....

<?php

mysql_select_db("$database");

    $sql = "select test, rate FROM product";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
   echo <<<EOL
<input type="checkbox" name="name[]" value="{$row['test']}-{$row['rate']}" /> {$row['test']}-{$row['rate']}<br />

EOL;
}
?>

Any help will be appreciated.

Answer 1

You'll need to implement your logic in PHP code like this:

<?php
$input_fields = array();
$rows_per_column = 10;

mysql_select_db("$database");

$sql = "select test, rate FROM product";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
    $input_fields[] =<<<EOL
<input type="checkbox" name="name[]" value="{$row['test']}-{$row['rate']}" /> {$row['test']}-{$row['rate']}
EOL;
}

echo "<table><tr>";

foreach ($input_fields as $i => $value){
    if ($i % $rows_per_column == 0){
        echo '<td valign="top">';
    }
    else{
        echo '<br>';
    }

    echo $value;

    if ($i % $rows_per_column == $rows_per_column - 1 || $i == count($input_fields) - 1){
        echo '</td>';
    }
}

echo "</tr></table>";