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
pass around a "page" number or a "start record" number. Use that to
determine where to start (and therefore where to end)
eg: page = 1.'. start record = (1-1)*25+1 => 1
eg: page = 3.'. start record = (3-1)*25+1 => 51
HTH
Martin
-Original Message-
From: Aqua [mailto:[EMAIL PROT
11 matches
Mail list logo