phplib-users

[Phplib-users] SQL query on more than one page

[Marek S. <so...@gm...>]

Hello,
I want to print a SQL query on more than one page. The DB table
does not have an index. How can I realize the pages functionality
easily ?
Regards,
MAREK.

Re: [Phplib-users] SQL query on more than one page

[Stephen W. <wo...@sw...>]

SELECT .... LIMIT FIRST_ROW_NUMBER, NUMBER_OF_ROWS

Marek Siegle wrote:
> 
> Hello,
> I want to print a SQL query on more than one page. The DB table
> does not have an index. How can I realize the pages functionality
> easily ?
> Regards,
> MAREK.
> 
> _______________________________________________________________
> 
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> 
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users

Re: [Phplib-users] SQL query on more than one page

[anze <an...@vo...>]

Hi!

> SELECT .... LIMIT FIRST_ROW_NUMBER, NUMBER_OF_ROWS
As far as I know this only works on MySQL...

Anze

Re: [Phplib-users] SQL query on more than one page

[Marco P. <pr...@te...>]

On Fri, May 31, 2002 at 03:38:02PM +0200, anze wrote:
> Hi!
> 
> > SELECT .... LIMIT FIRST_ROW_NUMBER, NUMBER_OF_ROWS
> As far as I know this only works on MySQL...

On PostgreSQL it works, but with parameters swapped w.r.t.
the above example.

Marco Pratesi