Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199908

Re: [PHP3] Spliting reports from oracle queries From: Aaron Leon Kaplan (jjl <email protected>)
Date: 08/04/99

On Wed, 4 Aug 1999, Alessandro Oliveira wrote:

> Hi,
>
> Anybody knows how to split a report in many pages like search engines
> using oracle databases and PHP.
>

How about using a counter as column and selecting only those rows where
the value of the counter is e.g. between 1 and 15?

An example from the scott/tiger demo tables:

SELECT rownum, employee from dept,dual WHERE rownum >= 1 AND rownum <= 15;

rownum is a special pseudo column in oracle. I think you need the "dual"
table as a consequence.

>
> Thanks for your Help !

welcome.

Aaron.

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>