Re: browsing sorted resultsets from an oracle db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



try steping like this:
1. select all you have to find; like dates[][] ..the result is a matrix if you have more then one field
2. register that values with session_register("dates")
3. in every page you have to put a starting counter with it you have to display the values starting with... like "show_results.php?start=100" 
and the next "show_results.php?start=110"
4. in "show_results.php" you have to extract the parameter with GET ..$start_counter=$_GET['start'];
and global $dates; display the $dates[$start_counter=$i]...

cybercop78

On Mon, 13 Jan 2003 16:57:42 +0100, Markus Mirsberger wrote
> Hi,
> 
> I got the following ( simple :) ) problem. I have like 1 million 
> keys and I want to browse through them ....like"show next 10" or 
> "show last 10" or "show next" or "show last" for example. this is 
> pretty easy in mysql but for some reason not in oracle:) The first 
> solution I had is to have a subselect where I select all data, 
> number it and select the data I want to show from this subselect. 
> But every single site takes ages to load and its not very 
> intelligent to get all data first, number it and then just select 
> like 100 rows from that subselect :) I think many people have/had 
> this problem but I didnt find anything while searching the web.
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php





http://www.idilis.ro - Stiri, e-mail gratuit, download,
SMS, server de counter-strike, hosting gratuit, servicii internet...
Fii cu un pas inaintea celorlati!


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux