Ciao mi aiutate ho seguito un tutorial, ma non riesco a capire perchè il codice funziona a metà
eccolo:
<?php
$error = "error connect die";
mysql_connect("localhost", "root", "")or die($error);
mysql_select_db("paging")or die($error);
$per_page= 5;
$start =$_GET['start'];
$record_count = mysql_num_rows(mysql_query("SELECT * FROM user"));
$max_pages = $record_count/$per_page;
if (!$start)
$start = 0;
$get =mysql_query("SELECT * FROM user LIMIT $start, $per_page");
while($tupla = mysql_fetch_assoc($get)){
$nome = $tupla['nome'];
$eta = $tupla['eta'];
echo"$nome"." "."($eta)
";
}
$prev = $start - $per_page;
$next = $start + $per_page;
if(!($start<=0)){
echo"<a href ='index.php?$start=$prev'>prev </a>";
}
$i=0;
for($x =0;$x <$record_count;$x=$x+$per_page){
echo"<a href ='index.php?$start=$x'>$i</a>";
$i++;
}
if(!($start >= $record_count - $per_page)){
echo"<a href ='index.php?start=$next'>next</a>";
}
?>