2005/9/1, Vladimir B. Tsarkov <[EMAIL PROTECTED]>: > 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.
FTFM : " For compatibility with PostgreSQL, MySQL also supports the LIMIT row_count OFFSET offset syntax." but if you want to be fully compatible with many others RDBMS, go for something like adodb, or some others DB interface in PHP > > Thanks! > > -- > Good Luck! > Vladimir > > Please avoid sending me Word or PowerPoint attachments. > See http://www.gnu.org/philosophy/no-word-attachments.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]