$sql = "SELECT img_cat_header, id FROM CSW_athena_category WHERE id = '$n' AND img_cat_header !=''";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
echo "";
}
?>
echo "$nomecat"; ?>
if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$max_results = 9;
$from = (($page * $max_results) - $max_results);
$sql = "SELECT id, lingua2_prod_titolo, img_cat_puls FROM CSW_athena_prod WHERE categoria LIKE '$n' ORDER by Id DESC LIMIT $from, $max_results";
$result = mysql_query($sql,$conn)
or die("impossibile eseguire il comando");
while ($riga = mysql_fetch_row($result)) {
list($width, $height, $type, $attr) = getimagesize("images/$riga[2]");
if ($width > $height) {
$pic = "";
}else{
$pic = "";
}
echo " ";
}
?>
-
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM CSW_athena_prod WHERE categoria LIKE '$n'"),0);
$total_pages = ceil($total_results / $max_results);
$piuuno = $page + 1;
$piudue = $page + 2;
$piutre = $page + 3;
$menouno = $page - 1;
$menodue = $page - 2;
$menotre = $page - 3;
if($piuuno > $total_pages){
$piuuno = $total_pages;
$piu = "";
} else {
$piuuno = $page + 1;
$piu = "
- $piuuno "; } if($menouno < 1){ $menouno = 1; $meno = ""; } else { $menouno = $page - 1; $meno = "
- $menouno "; } if($menodue < 1){ $menodue = 2; $meno2 = ""; } else { $menodue = $page - 2; $meno2 = "
- $menodue "; } if($menotre < 1){ $menotre = 3; $meno3 = ""; } else { $menotre = $page - 3; $meno3 = "
- $menotre "; } if($piudue > $total_pages){ $piudue = $total_pages; $piu2 = ""; } else { $piudue = $page + 2; $piu2 = "
- $piudue "; } if($piutre > $total_pages){ $piutre = $total_pages; $piu3 = ""; } else { $piutre = $page + 3; $piu3 = "
- $piutre "; } if($page < 2){ $cinque = "
- 5 "; } else { $cinque = ""; } if($page < 4){ $sette = "
- 7 "; } else { $sette = ""; } if($page < 3){ $sei = "
- 6 "; } else { $sei = ""; } if($total_pages > 10){ echo "
- |«
- « $meno3$meno2$meno
- $page $piu$piu2$piu3$cinque$sei$sette
- »
- »| "; } else { for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "
- $i "; } else { echo "
- $i "; } } } ?>