Use paging page to display 10-20 rows per page.
$sql = "select n * skip x from [table] ..."
n= number of rows to display
x= start from record (filtered and/or ordered)

if u need the sample script and classess, contact me directly

--m

> Hello,
>
> I would like to know what happens when a user clicks on the "Stop"
> button of a browser while a php script is returning the results of a
> Firebird query. Imagine the script is in that moment accessing the
> results of a query with a loop like this:
>
> $dbh = ibase_connect(.....);
> $stmt = "SELECT BLA, BLA...";
> $sth=ibase_query($dbh,$stmt)
> while ($row=ibase_fetch_object($sth)
> {
> ... printing result in the client browser
> }
>
> If the result of the query is big enough, it may take some time to show
> all the rows in the browser, and the user may get tired of waiting. If
> he stops the script, does firebird continue processing the query until
> it finishes?
>
> I hope my question is understood. I don't know if this has to do with
> the webserver or with firebird, and would appreciate any commments on
> this.
>
> Thanks,
>
> Xavier.
>
> -------------------------------------------------
> Xavier Solé - x.sole@...
> Cancer Epidemiology
> Catalan Institute of Oncology
> Av. Gran Via s/n, km. 2,7
> 08907 L'Hospitalet de Llobregat,
> Barcelona, Catalonia.
> Tel: +34 93 260 74 01
> Fax:+34 93 260 77 87
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/