how many rows? [was Re: fetching rows]

"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 )