[PHP-DB] Hi all, how the sript to view like...

[Hadi]

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