> result set. Chris, you've made a believer out of me; I'll start using
> mysql_fetch_assoc() for these kinds of queries from now on.
> And in the spirit of only retrieving what you need from the database, I
> would agree that mysql_fetch_assoc() is the "better" option. However, other
> than maybe making my script run a little more slowly, I fail to see how
> mysql_fetch_array() is a bad thing. From what I can see, all it does is give
> me an additional numerically indexed reference to the data in my result set
> and if I choose to ignore it, then that's my choice. If it causes a
> significant slowdown in the performance of my script, then it's certainly a
> candidate for optimization.
> Am I missing something else?
foreach(); list(); each();
None are good ideas when iterating through an array generated by *_array().
And I'd hazard to guess that one of the most significant uses of any query is
to iterate through it's result set.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php