Re: no temp var for mysql_fetch_array results

From: 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!

« previous php.db (#34373) next »