"Robert B. Easter" wrote:
>
> > you can't do that with a cursor, but you can use they mysql-ism called a
> > limit clause. for example, to fetch rows 26-50 from that query, you'd
> > do:
> >
> > select * from films limit 25,26;
> >
> > or
> >
> > select * from files limit 25 offset 26;
I did know it was possible but did not know how to do, thanks (It was
not my question but I'm glad to see the solution:)
and how can I know how many rows are returned by the query?
--
Arnaud
( http://www.ressource-toi.org )