Re: [PHP-DB] Paging

2009-05-13 Thread Bastien Koert
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

[PHP-DB] Paging

2009-05-11 Thread Joey Hendricks
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

[PHP-DB] Paging large recordsets

2004-02-13 Thread Karen Resplendo
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

Re: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
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

Re: [PHP-DB] Paging large recordsets

2004-02-13 Thread Robert Twitty
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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Hutchins, Richard
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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Paul Miller
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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
] 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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Robert Twitty
: 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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Paul Miller
: 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

RE: [PHP-DB] Paging large recordsets

2004-02-13 Thread Peter Beckman
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

Re: [PHP-DB] Paging help needed :-(

2001-07-12 Thread Dobromir Velev
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

Re: [PHP-DB] Paging help needed :-(

2001-07-12 Thread Roger Ramirez
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

[PHP-DB] Paging help needed :-(

2001-07-11 Thread chris
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