Re: no temp var for mysql_fetch_array results
| From: | David T-G | Date: | Tue, 11 May 2004 23:11:34 +0000 |
| Subject: | Re: no temp var for mysql_fetch_array results | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34373@lists.php.net to get a copy of this message | ||
Justin, et al --
..and then Justin Patrin said...
%
% David T-G wrote:
%
% >...and then jeffrey_n_Dyke@Keane.com said...
% >%
..
% >% How about:
% >% $i = mysql_result(mysql_query($q,$dbro),0);
% >
% >Oooh! Cool! Just right.
..
%
% Of course, this leaves the result handle open. It's best to store the
% result handle and free it with mysql_free_result().
Makes sense. I actually hadn't thought of that; do I need to do that
after a typical while(mysql_fetch_array()) or does the exhaustion caused
by the while loop then close and free for me?
Thanks & TIA & HAND
:-D
--
David T-G
davidtg@justpickone.org
http://justpickone.org/davidtg/ Shpx gur
Pbzzhavpngvbaf Qrprapl Npg!