Mam tabelę w bazie danych w której trzymam dane takie jak :
CREATE TABLE IF NOT EXISTS `galleries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nazwa` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`opis` text COLLATE utf8_polish_ci NOT NULL,
`ilosc` int(11) NOT NULL DEFAULT '1',
`linkz` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek1` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek2` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek3` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek4` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek5` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek6` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek7` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek8` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek9` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek10` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek11` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek12` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek13` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek14` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek15` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek16` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek17` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek18` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek19` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek20` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek21` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek22` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek23` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek24` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`obrazek25` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura1` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura2` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura3` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura4` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura5` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura6` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura7` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura8` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura9` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura10` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura11` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura12` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura13` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura14` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura15` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura16` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura17` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura18` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura19` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura20` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura21` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura22` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura23` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura24` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`miniatura25` varchar(100) COLLATE utf8_polish_ci NOT NULL,
`data` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=1 ;
Wgrywam dane do tej tabeli aby potem wyświetlić je skryptem takim:
<?php
include("config.php");
$id = $_GET['id'];
$zapytanie = $mysqli->query("SELECT * FROM `galleries` WHERE id='$id");
$wynik = $zapytanie->fetch_assoc();
$ilosc = $wynik['ilosc'];
for($i = 1; $i <= $ilosc; $i++){
$duzy = $wynik['obrazek'.$i.''];
$maly = $wynik['miniatura'.$i.''];
print '<a class="fancybox-buttons" data-fancybox-group="button" href="'.$duzy.'"><img src="'.$maly.'"/></a>'; }
?>