mysql_result vs. mysql_fetch_array

[flipdoubt]

Which is faster for retrieving results from a large mySQL query result: (a) a for loop with a call to mysql_result or (b) a for loop with a call to mysql_fetch_array? Obviously, mysql_result requires a call for each field you intend to output, but mysql_fetch_array must do a lot of copying ...

thanks

[[deleted]]

Try it and see...

But note: both methods retreive data differently, and you have to process the data differently. One fetch method may be faster than other, but it may also require a much more complex/slower method of processing.