static function vypis_zoznam() { $db = napoj_db(); $sql = <<<EOF SELECT * from POUZIVATELIA LEFT JOIN oddiely ON POUZIVATELIA.id_oddiel=oddiely.id ORDER BY oddiely.id IS NULL, oddiely.nazov;; EOF; $akt_oddiel = "."; $ret = $db->query($sql); while ($row = $ret->fetchArray(SQLITE3_ASSOC)) { if ($akt_oddiel != $row['nazov']) { $akt_oddiel = $row['nazov']; if ($akt_oddiel == "") { echo "<h2 class=ZC_nadpis>Bez oddielu</h2>"; } else { echo "<h2 class=ZC_nadpis>" . $akt_oddiel . "</h2>"; } } POUZIVATELIA::vypis_profil($row); } //echo "Operation done successfully"."<br>"; $db->close(); }