Re: browsing sorted resultsets from an oracle db

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!