Re: no temp var for mysql_fetch_array results

David T-G wrote:

Jeff (and John) -- ...and then jeffrey_n_Dyke@Keane.com said... % ... % > $r = mysql_query($q,$dbro) ; % > $row = mysql_fetch_array($r) ; % > $i = $row[0] ; ... % >this one row (not looping), could I just % > % > $i = mysql_fetch_array($r)[0] ; % % Hi David.... Hi!

%       How about:
%       $i = mysql_result(mysql_query($q,$dbro),0);

Oooh! Cool! Just right. % HTH % Jeff Thanks & HAND :-D

Of course, this leaves the result handle open. It's best to store the result handle and free it with mysql_free_result(). If you want to get one column's data (or one row even) you may want to look into a DB abstraction layer (such as PEAR DB or MDB). Or, of course, you could write your own function. function getOne($sql, $link) { $sth = mysql_query($sql, $link); $val = mysql_result($sth, 0); mysql_free_result($sth); return $val; } -- paperCrane <Justin Patrin>