[SOLVED] mysql_fetch_row or mysql_fetch_assoc or mysql_fetch_array?

[limitphp]

If you have a query where you know the result will only be 1 row, do you typically use mysql_fetch_row for that, or stick with mysql_fetch_assoc or mysql_fetch_array or something else?

 

Is there a speed advantage to using mysql_fetch_row?

 

Thanks

[flyhoney]

I imagine its negligible if there is a speed advantage.  Use whatever makes the code most readable.

[wildteen88]

If you have a query where you know the result will only be 1 row, do you typically use mysql_fetch_row for that, or stick with mysql_fetch_assoc or mysql_fetch_array or something else?

 

Is there a speed advantage to using mysql_fetch_row?

 

Thanks

 

In order to for you to know which to use you'll need to know what each of the above returns.

 

mysql_fetch_assoc - returns an associative array of your field names eg $row['field_name_here']

 

mysql_fetch_row - returns a numeric array eg $row[0] returns the first column, $row[1] returns the second column etc.

 

However mysql_fetch_array retuns both an associative and numeric array.

 

I personally use mysql_fetch_assoc.