polacz();
$wyc = $conn->query("SELECT genre, COUNT(*) tyle FROM spiewnik GROUP BY genre Order By genre Asc");//sqlite_query($baza,"SELECT genre,COUNT(*) FROM spiewnik GROUP BY genre Order By genre Asc");
$dane = $wyc->fetchAll();//sqlite_fetch_all($wyc);
foreach($dane as $wynik){
?>
[]
Pojedyńcze utwory:
query("SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ ?>
query("SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ ?>
-
Songbooki, kradzione:
query("SELECT * FROM spiewnik WHERE plik_type = 'songbook' ORDER BY title ASC"); $dane = $wyc->fetchAll(); //sqlite_close($baza); foreach($dane as $wynik){ ?>
query("SELECT * FROM spiewnik WHERE plik_type = 'songbook' ORDER BY title ASC"); $dane = $wyc->fetchAll(); //sqlite_close($baza); foreach($dane as $wynik){ ?>
-
Linki zewnetrzne:
query("SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ echo "![\""](images/" . $wynik["plik_type"] . ".gif)
" . $wynik["title"] . " - " . $wynik["band"] . " - " . $wynik["genre"] . "";
}
//
?>
query("SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ echo "
" . $wynik["title"] . " - " . $wynik["band"] . " - " . $wynik["genre"] . "