NYCPHP Meetup

NYPHP.org

[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