On Thu, January 26, 2006 2:27 pm, Sue wrote:
> I am retrieving records from a MySQL database and need to just display
> each
> record one after the other on a page. I only want to display a
> maximum of
> 25 records per page though, and am wondering if there is a way to
> handle
> this easily with
://content.weber-sites.com
-Original Message-
From: Sue [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 26, 2006 10:27 PM
To: php-general@lists.php.net
Subject: [PHP] Best way to handle PREVIOUS and NEXT processing of database
records retrieved
I am retrieving records from a MySQL
You could always use the LIMIT functionality in MySQL
SELECT * FROM table LIMIT 0,25
Then just pass the variables for the limit to start at and how many you want
returned in your query.
SELECT * FROM table LIMIT $start,$num_returned
So looking at records 26 through 50 your links would look like
I am retrieving records from a MySQL database and need to just display each
record one after the other on a page. I only want to display a maximum of
25 records per page though, and am wondering if there is a way to handle
this easily within PHP? I'd like to use something like NEXT and PREVIOU
4 matches
Mail list logo
