On Mon, May 11, 2009 at 9:07 PM, Joey Hendricks
wrote:
> Hi everybody, I have a paging question. I have a page where you can view a
> persons 'profile'. And I have a list taken from the db of there books. I can
> get all the books on one page but I can't figure out the WHERE from the get.
> This i
Hi everybody, I have a paging question. I have a page where you can view a
persons 'profile'. And I have a list taken from the db of there books. I can
get all the books on one page but I can't figure out the WHERE from the get.
This is what I tried but it didn't work.
$query = "SELECT COUNT(*
On Fri, 13 Feb 2004, Robert Twitty wrote:
> If you are not opearating in a stateless environment, then you could use a
> cursor. The web is a stateless environment, and therefore the record set
> needs to be cached either to disk or memeory. The other alternative is to
> rerun the query for each
: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 1:59 PM
To: Paul Miller
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Paging large recordsets
If you are not opearating in a stateless environment, then you could use
a cursor. The web is a stateless environment, and therefore the
t; - Paul
>
> -Original Message-
> From: Robert Twitty [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 13, 2004 12:34 PM
> To: Karen Resplendo
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Paging large recordsets
>
>
> Most of the PHP solutions I have s
ltsperpage'].",
".($conf['maxresultsperpage']*$_REQUEST['page'])-10);
// loop through array returned from mysql
echo "Next";
I think. It might need some tweaking, but you get the idea (I hope).
No need to store variables here.
Beckman
>
should not store large amounts of data would be disk
write/read speed per user.
Can someone clarify this for me?
- Paul
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 12:34 PM
To: Karen Resplendo
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
t; To: Karen Resplendo
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Paging large recordsets
>
>
> Most of the PHP solutions I have seeen require the use of session
> variables. You could create an array containing only the unique
> identifiers of all the records, and then st
Most of the PHP solutions I have seeen require the use of session
variables. You could create an array containing only the unique
identifiers of all the records, and then store it into a session variable.
You would then use another session variable to retain the page size, and
then include the pag
On Fri, 13 Feb 2004, Karen Resplendo wrote:
> I guess the time has come that my boss wants "Next", "Previous", "First",
> "Last" paging for our data displays of large recordsets or datasets.
First, do a query to find out how many rows.
select count(*) from table where (your where clauses for t
I guess the time has come that my boss wants "Next", "Previous", "First", "Last"
paging for our data displays of large recordsets or datasets.
Any good solutons out there already? I have pieces of a few examples.
Also, how to deal with printing? I would assume that the ideal page size is not t
offset will be.
$offset = ( $page - 1 ) * $total_pages;
$sql = "SELECT id, email, name, subject, url, image2, comments, dat
FROM users
ORDER BY id DESC
LIMIT $offset,$records_per_page";
And that's it? Simple eh?
You may also want to put out something like: ec
efine how many records to show in a page and etc.
Dobromir Velev
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, July 12, 2001 7:53 AM
Subject: [PHP-DB] Paging help needed :-(
Hi there Everyone,
I curre
Hi there Everyone,
I currently have a dedicated Apache server with PHP 4.06, MySQL etc .. installed and
running fine. Below is alittle peice of code that I would love an answer to:
then all the HTML and display bits (Example at www.planetoxygene.com in the guestbook).
Now my questio
14 matches
Mail list logo
