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
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
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
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;
>
>
I guess there are good articles on this at phpbuilder.com
http://www.phpbuilder.com/columns/rod20001214.php3
http://www.phpbuilder.com/columns/rod2221.php3
hope that helps
best regards
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
- Original Message -
From: "Randy Jo
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
6 matches
Mail list logo
