Re: page splitting

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: [PHP-DB] 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>"; } ?>