Hello,
James Crowley wrote:
>
> Hi,
> I want to spread the results of a recordset over a number of pages. In ASP,
> I would have opened a connection with a client-side cursor... but with PHP
> (using it's ODBC functions), it only seems to be able to execute an SQL
> statement, and return all the results... which isn't very efficient if I
> have 500 results with 10 per page!
> Also, how do I change the cursor location?
You may want to look at Metabase, a PHP database abstraction package
does that working similarly when using MySQL LIMIT clause, but it works
with all supported databases including those using ODBC. It is as simple
as calling the function
MetabaseSetSelectedRowRange($database,$first,$limit) before each query.
You may find Metabase here:
http://phpclasses.UpperDesign.com/browse.html/package/20
You may also want to try this PHP Class that displays query results in
HTML tables with links to go back and forth between pages.
http://phpclasses.UpperDesign.com/browse.html/package/130
Manuel Lemos
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
