php3-list | 199908
Date: 08/04/99
- Next message: Aaron Leon Kaplan: "Re: [PHP3] Printing textarea fields..."
- Previous message: Teodor Cimpoesu: "Re: [PHP3] PHP Documentation"
- In reply to: Alessandro Oliveira: "[PHP3] Spliting reports from oracle queries"
- Next in thread: Nold: "Re: [PHP3] Spliting reports from oracle queries"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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>
- Next message: Aaron Leon Kaplan: "Re: [PHP3] Printing textarea fields..."
- Previous message: Teodor Cimpoesu: "Re: [PHP3] PHP Documentation"
- In reply to: Alessandro Oliveira: "[PHP3] Spliting reports from oracle queries"
- Next in thread: Nold: "Re: [PHP3] Spliting reports from oracle queries"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

