Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //řazení po řádcích
- $result = mysqli_query($link, "select den from dny");
- define ("COLS", 3); // počet sloupců
- echo "<table>\n";
- for ($i = 0; $zaznam = mysqli_fetch_assoc($result); $i++)
- {
- if ($i % COLS == 0) echo "<tr>";
- echo "<td>".($i+1).". ".$zaznam['den']."</td>";
- if ($i % COLS == COLS - 1) echo "</tr>\n";
- }
- if ($i % COLS != 0)
- {
- while ($i++ % COLS != 0)
- {
- echo "<td> </td>";
- }
- echo "</tr>\n";
- }
- echo "</table>\n";
- //řazení po sloupcích
- $result = mysqli_query($link, "select den from dny");
- while ($line = mysqli_fetch_assoc ($result))
- $zaznamy[] = $line;
- define ("COLS", 3);
- $pocetRadku = ceil(count ($zaznamy) / COLS);
- echo "<table>\n";
- for ($i = 0; $i < $pocetRadku; $i++)
- {
- echo "<tr>";
- for ($j = 0; $j < COLS; $j++)
- {
- echo "<td>";
- if (isset($zaznamy[$j*$pocetRadku + $i]))
- echo ($j*$pocetRadku + $i + 1).". ".$zaznamy[$j*$pocetRadku + $i]['den'];
- else
- echo " ";
- echo "</td>";
- }
- echo "</tr>\n";
- }
- echo "</table>\n";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement