Re: mysql_fetch_array() VS mysql_result()

On Wed, 7 Jun 2000, Svetlin Simeonov wrote: > Hi, > > I read that mysql_fetch_array() is more fast than mysql_result() but I > don't know whether my script will work ? > I want to use it in queries wich will return more than 1 row , But in > docs I can't find that mysql_fetch_array can read specified line number > ... lets say 38 > > In mysql_result I can say: > > mysql_result($conn_to_sql, $rownum, "column"); > > Can I use in this situation MySQL_Fetch_Array(); ??? No, and that's why mysql_fetch_array is faster. :) This operation that mysql_result does is extremely resource intensive. IMHO, in most cases, you're better off using mysql_fetch_array or mysql_fetch_result and iterating through the result until you find the field you're looking for. Matt