Re: [PHP] paging results in large resultsets: mysql vs postgresql?

2006-06-15 Thread Richard Lynch
On Thu, June 15, 2006 7:15 pm, D. Dante Lorenso wrote: > Richard Lynch wrote: >> 3. use the built-in "cursor" of PostgreSQL which pre-dates MySQL >> LIMIT and OFFSET clauses, which are non-standard hacks Rasmus >> introduced back in the day. > > Care to elaborate? Cast into context of PDO if y

Re: [PHP] paging results in large resultsets: mysql vs postgresql?

2006-06-15 Thread D. Dante Lorenso
Richard Lynch wrote: 3. use the built-in "cursor" of PostgreSQL which pre-dates MySQL LIMIT and OFFSET clauses, which are non-standard hacks Rasmus introduced back in the day. Care to elaborate? Cast into context of PDO if you can...? Dante -- PHP General Mailing List (http://www.php.net/) T

Re: [PHP] paging results in large resultsets: mysql vs postgresql?

2006-06-15 Thread Richard Lynch
On Thu, June 15, 2006 11:11 am, D. Dante Lorenso wrote: > I just discovered this neat little gem in MySQL which makes it easy to > page large result sets: > > * SELECT SQL_CALC_FOUND_ROWS * > > * SELECT FOUND_ROWS() > > I can't seem to find the equivalent of it in PostgreSQL! The only > o

Re: [PHP] paging results in large resultsets: mysql vs postgresql?

2006-06-15 Thread tedd
At 11:11 AM -0500 6/15/06, D. Dante Lorenso wrote: >I can't seem to find the equivalent of it in PostgreSQL! The only options I >see are: > > 1. > > TWO queries. The first query will perform a SELECT COUNT(*) ...; and the > second query performs the actualy SELECT ... LIMIT x OFFSET y; > >

[PHP] paging results in large resultsets: mysql vs postgresql?

2006-06-15 Thread D. Dante Lorenso
All, I just discovered this neat little gem in MySQL which makes it easy to page large result sets: * SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT 10, 10 * SELECT FOUND_ROWS() The neat thing is that SQL_CALC_FOUND_ROWS will cause MySQL to tally up all the rows that WOULD ha

Re: [PHP] Paging results

2001-02-14 Thread Ankur Verma
Randy Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 15, 2001 2:12 AM Subject: [PHP] Paging results > Can somebody give me a url of an example or an example of how to page > results so they can be view by clicking page 1 page 2 or back an

Re: [PHP] Paging results

2001-02-14 Thread David Robley
On Thu, 15 Feb 2001 07:12, Randy Johnson wrote: > Can somebody give me a url of an example or an example of how to page > results so they can be view by clicking page 1 page 2 or back and > next? > > results obtained from mysql database. > > Thanks > > Randy http://px.sklar.com/code.html?code

[PHP] Paging results

2001-02-14 Thread Randy Johnson
Can somebody give me a url of an example or an example of how to page results so they can be view by clicking page 1 page 2 or back and next? results obtained from mysql database. Thanks Randy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For