Alguem sabe como?
<?php
mysql_connect('localhost','root','');
mysql_select_db('banco');
$view = 10; // quantidade de registros a serem exibidos
$pages = (isset($_GET['pag'])) ? (int)$_GET['pag'] : 1; // verifico se a GET pag existe, caso nao existe crio.
$start = ($view * $pages) - $view;
$sql = "SELECT * FROM users ORDER BY id ASC LIMIT $start, $view";
$qr = mysql_query($sql);
while ($ln = mysql_fetch_array($qr)) {
echo $ln['name'] . '<br />';
}
/*** paginação ***/
$sql2 = "SELECT id FROM users";
$qr2 = mysql_query($sql2);
$total = mysql_num_rows($qr2);
$totalpag = ceil($total/$view);
$next = ($pages+1);
$prev = ($pages-1);
echo "Página $pages de $totalpag";
if($pages == 1) {
echo "";
} else {
echo "<a href='index.php?pag=$prev'>Anterior</a>";
}
for($i = 1; $i <= $totalpag; $i++) {
if($pages == $i) {
echo " $i ";
} else {
echo " <a href='$i'>$i</a> ";
}
}
if($pages == $totalpag) {
echo "";
} else {
echo "<a href='index.php?pag=$next'>Proxima</a>";
}
?>
Ninguem?