Re: LIMIT alternative

[Bastian Balthazar Bux]

Vladimir B. Tsarkov wrote:
> Hello!
> 
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other 
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a 
> portable PHP pager for a web site, but all the tutorials that I've found, 
> contain solutions based on the LIMIT usage.
>  
> Thanks!
> 

take a look at the code of adodb
http://adodb.sourceforge.net

and to it's implementation of:
SelectLimit($sql,$numrows=-1,$offset=-1,$inputarr=false)