Well, you haven't told us what database you're using at all, but I'll
assume MySQL. In which case you should look at the LIMIT part of your
query.
http://www.mysql.com/doc/en/SELECT.html
All you need to do is pass around a starting point variable on each
page, so that you know where the resul
a sample from my db class, i had to store the total in a session as calling
the total on every page on a large database was painful doing count(*) or
even SQL_CALC_FOUND_ROWS, on a small database u just cant tell but on a
database of 100k + it was painful to load each page ;)
function page_query($
100k = 100k records = 200 meg hehe
> a sample from my db class, i had to store the total in a session as
> calling the total on every page on a large database was painful doing
> count(*) or even SQL_CALC_FOUND_ROWS, on a small database u just cant
> tell but on a database of 100k + it was painful
If you're using CGI/Perl, WHY WHY WHY are you asking questions on a PHP
list?
I've given you a hint, so perhaps take that hint and ask a question on
an Oracle list, or search the Oracle documentation for similar
functions.
Justin French
On Tuesday, August 5, 2003, at 10:37 PM, Coello, David
On Thursday 27 June 2002 21:22, Erik Price wrote:
> On Thursday, June 27, 2002, at 02:56 AM, Justin French wrote:
> > Use the LIMIT function in your SELECT query... check out the MySQL
> > manual...
> > and then generate back / forward links depending on your current
> > offset. It
> > should be
On Thursday, June 27, 2002, at 02:56 AM, Justin French wrote:
> Use the LIMIT function in your SELECT query... check out the MySQL
> manual...
> and then generate back / forward links depending on your current
> offset. It
> should be expandable to 1000 records without any mods to the code.
limit $numInc,2";
...
Previous";
$numIncs = $numInc + 2;
echo " / Next";
?>
..
- Original Message -
From: Justin French <[EMAIL PROTECTED]>
To: Aqua <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 3:09 PM
Subject: Re: [PH
gt; From: Justin French <[EMAIL PROTECTED]>
> To: Aqua <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, June 27, 2002 1:56 PM
> Subject: Re: [PHP] Display Records in Multiple Pages
>
>
>> Use the LIMIT function in your SELECT query... check out the My
:56 PM
Subject: Re: [PHP] Display Records in Multiple Pages
> Use the LIMIT function in your SELECT query... check out the MySQL
manual...
> and then generate back / forward links depending on your current offset.
It
> should be expandable to 1000 records without any mods to the code.
>
&g
Use the LIMIT function in your SELECT query... check out the MySQL manual...
and then generate back / forward links depending on your current offset. It
should be expandable to 1000 records without any mods to the code.
Justin French
on 27/06/02 4:54 PM, Aqua ([EMAIL PROTECTED]) wrote:
> I h
ssage-
From: Aqua [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 4:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Display Records in Multiple Pages
I have 100 records in mySQL database and I need to display them in my web
page using php and html. How to display them in multiple pages? Eac
I have 100 records in mySQL database and I need to display them in my web page using
php and html. How to display them in multiple pages? Each page must contain 25
records. Does anyone know how to do it other than create 4 pages and manually list the
records there? or maybe point me some refere
12 matches
Mail list logo
