$showPerPage = 1; // datensätze pro seite
if(!isset($_GET['p']))
$actPage = 1;
else
$actPage = $_GET['p'];
// 1. query für die anzahl
$sql = 'SELECT COUNT(*) from affilinet_shop where affilinetProductCategoryID = 126';
$res = mysql_query($sql) or die(mysql_error());
$anz = mysql_fetch_array($res);
$count = mysql_fetch_row($res);
srand((double)microtime()*1000000);
$zufall = @rand(1,$count[0]);
$totalPages = ceil($anz[0]/$showPerPage);
$linkTo = "../Shop-Mode/";
// 2. query mit LIMIT um die richtigen datensätze zu holen
$sql = 'SELECT ID, ArtNumber, Title, Description_short, Img_url, DeepLink1, ProductCategoryID, Img120_url, ProductCategoryName, ProductCategoryID, DisplayPrice, Keywords, Manufacturer, Description, affilinetProductCategoryID, affilinetProductCategoryName
FROM affilinet_shop where affilinetProductCategoryID = 126 order by rand()
LIMIT '. (($actPage-1) * $showPerPage) .', '. $showPerPage .'';
$res = mysql_query($sql) or die(mysql_error());