I have my database page look like this:
[1] [2] [3] [4] [5] [6]
the problem is when I have my database growing it will be not nice to look
at because the number will keep growing,
how to make it like this :
<<< 1 2 3 4 >>>
Thanks for the help
require("cobaconfig.php");
$numresult = mysql_query("select * from dataiklanbaris order by id desc");
$total = mysql_num_rows($numresult);
$limit = 20;
if (empty($offset)) {
$offset = 0;
}
$query = "select * from table order by id desc limit $offset, $limit";
$result = mysql_query($query);
$halaman = intval($total/$limit);
if ($jumlah%$limit) {
$page++;
}
for ($i = 1; $i<=$page; $i++) {
$newoffset=$limit*($i-1);
if ($offset != $newoffset) {
echo " [<a href=\"view.php?offset=$newoffset\">$i</a>]";
} else {
echo "[$i]";
}
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
