raga cosa c'èm di sbagliato qui:
Codice PHP:
<html>
<head>
<title>paginazione</title>
</head>
<body>
<center>
<?php
$res_count=0;
$tot_records=0;
$tot_pages=0;
// connessione al database
mysql_connect("localhost", "root", "") or die("Connessione fallita !");
// selezione del DB
mysql_select_db("a") or die("Selezione del DB fallita !");
// esecuzione prima query
$count = mysql_query("SELECT * FROM tab");
$res_count = mysql_fetch_row($count);
// numero totale di records
$tot_records = $res_count[0];
// risultati per pagina(secondo parametro di LIMIT)
$per_page = 15;
// numero totale di pagine
$tot_pages = ceil($tot_records / $per_page);
// pagina corrente
@$current_page = (!$_GET['page']) ? 1 : (int)$_GET['page'];
// primo parametro di LIMIT
$primo = ($current_page - 1) * $per_page;
echo "<center><div align=\"center\">\n<table>\n";
// esecuzione seconda query con LIMIT
$query_limit = mysql_db_query("a","SELECT * FROM tab LIMIT $primo, $per_page");
for($i=0;$i<15;$i++) {
$numero=mysql_result($query_limit,$i,"numero");
$nome=mysql_result($query_limit,$i,"nome");
$data=mysql_result($query_limit,$i,"data");
echo " <tr>\n <td>";
echo $numero,$nome,$data;
echo "</td>\n </tr>\n";
}
// includiamo uno dei files contenenti la paginazione, commentate l'altro ovviamente
include("pag1.php");
// in questa cella inseriamo la paginazione
echo " <tr>\n <td height=\"50\" valign=\"bottom\" align=\"center\">$paginazione</td>\n";
echo " </tr>\n</table>\n</div></center>";
mysql_close();
?>
</center>
</body>
</html>
ogni volta ke lo guardo mi da errori diversi... O.o
ad esempio le pagine decide lui a cazzo quante siano O.o poi ogni tanto mi da questi errori
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 2 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 2 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 2 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 3 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 3 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 3 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 4 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 4 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 4 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 5 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 5 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 5 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 6 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 6 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 6 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 7 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 7 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 7 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 8 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 8 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 8 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 9 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 9 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 9 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 10 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 10 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 10 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 11 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 11 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 11 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 12 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 12 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 12 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 13 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 13 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 13 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
Warning: mysql_result(): Unable to jump to row 14 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 48
Warning: mysql_result(): Unable to jump to row 14 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 49
Warning: mysql_result(): Unable to jump to row 14 on MySQL result index 4 in c:\programmi\easyphp1-8\www\a\prov.php on line 50
vi prego aiutatemi