Or try the attached code
Nikos
----- Original Message -----
From: "Maxim Maletsky" <maxim@php.net>
To: "Shahar Tal" <admin@websitefaq.com>
Cc: <php-db@lists.php.net>
Sent: Sunday, February 02, 2003 7:30 PM
Subject: Re: page splitting
>
> you should get a class that does that. PHP Classes (phpclasses.org) is a
> good place to start
>
> --
> Maxim Maletsky
> maxim@php.net
>
>
> On Sun, 2 Feb 2003 17:37:12 +0200 "Shahar Tal" <admin@websitefaq.com>
wrote:
>
> > Hello all!
> >
> > First of all i'd like to say thanks. many of you helped me here a lot,
and I
> > can't thank you enough for it.
> >
> > For my next question.
> > I have a query. it takes up all the rows from a certain database, and
> > displays them.
> > I want to do the simple thing, page splitting. make it show a certain
number
> > of records everytime, let's say, 10, and then
> > automatically show the links like [<<] 1 2 3 [>>] to move between the
pages.
> >
> > I'm looking for the most simple and easy way to do it, as it should be a
> > very easy thing to do.
> >
> > Thank you all, once again :)
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
<?
$conn=mysql_connect($hostname, $user, $pass);
$rows_per_page=20;
$sql="SELECT * FROM table";
$result=mysql_db_query($database, $sql, $conn) or Die (mysql_error());
$total_records=mysql_num_rows($result);
$pages=ceil($total_records / $rows_per_page);
mysql_free_result($result);
?>
<html code>
<?
if (!isset($screen)) $screen=0;
$start=$screen * $rows_per_page;
$sql="SELECT col1, col2, ... FROM table";
$sql.="LIMIT $start, $rows_per_page";
$result=mysql_db_query($database, $sql, $conn) or Die (mysql_error());
while (list($col1, $clo2, ...)=mysql_fetch_row($result)) {
echo "....";
}
if ($screen>0) {
$url="$PHP_SELF?screen=$screen-1;
echo "<a href=\"$url\"> << </a>\n";
}
for ($i=0; $i<$pages; $i++) {
$I=$i+1;
$url="$PHP_SELF?screen=" . $i;
echo "<a href=\"$url\">".$I."</a>";
}
if ($screen < $pages-1) {
$url="$PHP_SELF?screen=";
$url .= $screen+1;
echo "<a href=\"$url\" class=\"menu3\"> >> </a>";
}
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
