>Is there any portable alternative to LIMIT? I'd like
>to create a portable PHP pager for a web site ...
No, there's not a 'super SQL' which all SQL engines understand. To hide
the details of LIMIT | TOP from your apps, you can write a PHP funcion
which applies or updates the appropriate LIMIT | TOP clause in a given
query, depending on what the DBMS is. If you are writing against MySQL
5.0.2 or later, you might alternatively write MSSQL and MySQL stored
procs for that task.
Vladimir B. Tsarkov wrote:
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.