mi sbagliavo non funziona per niente osì ho provato come da manuale cioè con offset= (offset-1)* limit ed ora mi da errore in my_sql_fetch posto lo script
<?PHP
//pagina attuale
$page= $_GET['page'];
//vecchia pagina
$lastpage = $_GET['lastpage'];
//se il get nn mi restituisce nessun valore laspage = 1 e page = 1
if (empty($lastpage)){
$lastpage = 1;
}
if (empty($page)){
$page = 1;
}
$actualpage = $page;
//connessione al server e query
$nomeserver = "localhost";
$username = "";
$password = "";
$dbname = "my_rbrtone81";
$tablename = "immagini";
$myconn = mysql_connect($nomeserver);
$mydb = mysql_select_db($dbname,$myconn);
$mycountsql = "SELECT COUNT(*) FROM $tablename";
$result = mysql_query($mycountsql);
$total = mysql_result($result, 0, 0);
$limit = 2;
$numpages=ceil($total/$limit);
$offset = ($offset - 1)* $limit;
$my_var2_sql = "SELECT * FROM $tablename LIMIT $offset , $limit";
$myquery = mysql_query($my_var2_sql,$myconn);
while($myvalues = mysql_fetch_array($myquery)){
$io=$offset ;
$cartella = "images/";
$newfile = "temp/".$myvalues["file"];
$immagine = $myvalues["file"];
copy($cartella.$immagine, $newfile);
list($current_width, $current_height) = getimagesize($newfile);
$left = $current_width/2;
$top = $current_height/2;
$crop_width = 80;
$crop_height = 80;
$canvas = imagecreatetruecolor($crop_width, $crop_height);
$current_image = imagecreatefromjpeg($newfile);
imagecopy($canvas, $current_image, 0, 0, $left, $top, $current_width, $current_height);
$img = imagejpeg($canvas, $newfile, 100);
if ($img == 1) {
$cartellal = "big.php?immagine=$cartella$immagine";
$larghezza = 60;
echo "<a href=\"javascript:finestra('$cartellal', '$img');\"><img src=\"$newfile\" height=\"$larghezza\" </a>";
}
$io++;
}
if ($page == 1)
echo "Previous";
else
echo "<a href=\"visualizzazione_file.php?page=" . ($page - 1) . "&lastpage=".$actualpage."&offset=".$offset."\">Pr evious</a>";
if ($page == $numpages)
echo "Next";
else
echo "<a href=\"visualizzazione_file.php?page=" . ($page + 1) ."&lastpage=".$actualpage."&offset=".$offset."\">N ext</a>";
mysql_close($myconn);
?>