[nycphp-talk] DB resultset
Sol
sol2ray at yahoo.fr
Mon Jul 12 14:27:12 EDT 2004
--- Hans Zaunere <hans not junk at nyphp.com> wrote:
>
> > > There lies the issue - the resultset isn't
> stored by
> > > the database. What
> > > you really want is a cursor. However, I assume
> > > we're talking about
> > > MySQL, in which case there are no cursors
> (they're
> > > coming in MySQL 5.0).
> >
> > But what's wrong with using "mysql_data_seek()"
>
> Nothing, but it isn't a true cursor.
>
> A database cursor (at least in common terms) is
> where the result set is
> stored on the server and client side API calls can
> operate on it
> completely - generally known as scrollable cursors.
> mysql_data_seek()
> works on the results after they've been stored on
> the client side as a
> result of using mysql_query().
Ok, since it is stored on the client and using
mysql_data_seek I can scroll through it back and
forth, isn't it better to just keep it where it is and
work with it?
=====
Sol Touré
PHPBTREE
http://phpbtree.com
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
More information about the talk
mailing list