Mam kod który pobiera mi dane do galerii zawiera on jednak sporo zapytań.
Mogę go trochę zoptymalizować?
$id = (int)$_GET['id'];
$liczba = 2;
$id = (int)$_GET['id'];
$liczba = 2;
$sql = $db->query('select * from galeria_foto where kategoria = "'.$kat.'" and id = "'.$foto.'"');
$row = $sql->fetch_array();
$numer = $row[numer];
$sql = $db->query('select * from galeria_foto where kategoria = "'.$kat.'" and id = "'.$foto.'"');
$num = $sql->num_rows;
$ile = ceil($num/$liczba);
if(!isset($_GET['id'])) $_GET['id'] = 0; $strona = (int)$_GET['id'];
$q = $db->query('SELECT `id` FROM `galeria_foto` WHERE `id` > "'.$foto.'" ORDER BY `id` ASC');
$wiersz = $q->fetch_array();
$quer = $db->query('SELECT `id` FROM `galeria_foto` WHERE `id` < "'.$foto.'" ORDER BY `id` DESC');
$wiersz_2 = $quer->fetch_array();
$sql = $db->query('select * from galeria_foto where id = "'.$foto.'"');
$num = $sql->num_rows;
$ile = ceil($num/$liczba);
if(!isset($_GET['id'])) $_GET['id'] = 0; $strona = (int)$_GET['id'];
$q = $db->query('SELECT `id` FROM `galeria_foto` WHERE `id` > "'.$foto.'" ORDER BY `id` ASC');
$wiersz = $q->fetch_array();
$quer = $db->query('SELECT `id` FROM `galeria_foto` WHERE `id` < "'.$foto.'" ORDER BY `id` DESC');
$wiersz_2 = $quer->fetch_array();
$zap = $db->query('select name,id from galeria_kategorie where id = "'.$kat.'"');
$r = $zap->fetch_array();
Pozdrawiam