--- In firebird-support@yahoogroups.com, "kishore_sairaj"
<kishore_sairaj@y...> wrote:

> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> > Hi,
> >
> > > How to use ROWNUM in Firebird.
> > >
> > > For Example if i want to execute following Query what
> modification I
> > > have to make.
> > >
> > > "Select * from emp where rownum>10 and rownum<20"
> >
> > Firebird doesn't have a "rownum" facility.
> >
> > But selecting a particular piece of a resultset if possible --
> > check the Firebird 1.5 release notes and look for "FIRST [n] [SKIP
> m]"
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &
> MS SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
>
> Hi Martin,
> Thanks for ur reply. Can u please tell me where can i get
> information on how to use write and use Firebird Stored Procedures
> with PHP.

You write stored procedures in Firebird

Look for LangRef.pdf at either www.firebirdsq.org or www.ibphoenix.com
It is part of the Interbase 6 documentation, and apart from a few new
features added in FB 1.5 (such as multi-action triggers and a few
context variables), it is up to date.

How you do it from php, contact that list, but I am guessing it is a
similar or the same way as you run any other insert or select query.

Adam