On Mon, May 11, 2009 at 9:07 PM, Joey Hendricks
j.hendrick...@comcast.netwrote:
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
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
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 the
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 the
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
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 store it into a
session variable.
You would
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
]
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 store it into a session
variable. You would then use another session variable
: 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 seeen require the use of session
variables. You could create an array containing only
: 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
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
records to
show, allow users to define 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
like: echo $page of $total_pages;
Enjoy.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 3:49 AM
Subject: [PHP-DB] Paging help needed :-(
Hi there Everyone,
I currently have a dedicated Apache server with PHP 4.06, MySQL etc ..
installed
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:
?php
$connection = mysql_connect(Localhost,username!!!,password!!!) or die(Couldn't
make a connection.);
$db
14 matches
Mail list logo