$pages ) $page = $pages; $limit = $page * $items_per_page; set_pageaction('Startseite'); pageHeader(); themeHeader(); print_title('Produktkatalog I-AM-HD'); openTable(); echo ' '; $sql = 'SELECT * FROM `galleries` WHERE `active`=1 ORDER BY `pos`'; $sql .= ' LIMIT '.$limit.','.$items_per_page; $r = zapytaj($sql); if ( mysql_num_rows($r) ) { echo ''; while($row = mysql_fetch_assoc($r) ) { $l = 'gallery.php?id='.$row['id'].'&title='.preg_replace('/[^A-Za-z0-9_]/', '_', $row['title']); $th = 0; if ($row['thumbnail']) { $sql = 'SELECT `thumb` FROM `pictures` WHERE `id`='.sql_quote($row['thumbnail']); $th = get_sql_value($sql); } if ( !$th ) { $sql = 'SELECT `thumb` FROM `pictures` WHERE `gallery`='.sql_quote($row['id']); $sql .= ' ORDER BY `pos` LIMIT 1'; $th = get_sql_value($sql); } echo ''; } echo '
'; if ($th) echo ''; echo ' '; echo htmlspecialchars($row['title']).' ('.(int)$row['pict'].')
'; }else{ echo 'Keine Produkte'; } pager($page, $ile, $items_per_page); closeTable(); themeFooter(); pageFooter(); ?>