Scriptindex.de

[ Menü ]

Home
News
Scripts
Neuzugänge
Suchen
Bücher
Manuals

[ Inhalt ]

Script eintragen
Tutorial eintragen
Newsletter
Umfragen
Link zu uns
Werbung bei uns
Kontakt
Impressum

[ Statistik ]

Hits gesamt: 5197585
Hits Heute: 624
max. Hits (10.07.07): 6964
User Online: 33
Scripts: 2828

[ Partner ]

CodeBase
I.S.U.M.
LUG Bayreuth
PEAR NEWS
PHP Classes

[ Facebook ]

[ Eigene Domain? ]

[ Buchtipp ]

Oracle, Java, XML. Integration in Oracle9i
Oracle, Java, XML. Integration in Oracle9i

Manuals > PEAR > DB_Common::limitQuery()

DB_Common::limitQuery()

DB_Common::limitQuery() -- send a limited query to the database

Description

Executes a SQL query, but fetches only the the specificed count of rows. It is an emulation of the MySQL LIMIT option.

Parameter

string $query

the SQL query

integer $from

the row to start to fetch

integer $count

the numbers of rows to fetch

Return value

mixed - a new DB_Result/ DB_OK or a DB_Error, if fail

Note

This function can not be called statically.

Warning

This module is EXPERIMENTAL. That means that the behaviour of these functions, these function names, in concreto ANYTHING documented here can change in a future release of this package WITHOUT NOTICE. Be warned, and use this module at your own risk.

Depending on the database you will not really get more speed compared to query(). The advantage of limitQuery() is the deleting of unneeded rows in the resultset, as early as possible. So this can decrease memory usage.


Copyright 1998 - 2009 by I.S.U.M.