MySQL fetch assoc VS mysql fetch array

Question

These are the commonly used methods to fetch MySQL data. 

1. mysql_fetch_array()

2. mysql_fetch_assoc()

For fetching data in loops (while) in a huge database which one is more efficient and easy?

Answer 1

The configuration of your tables will determine:

Essentially, mysql fetch array() gives back two arrays: one with a numeric index and the other with an associative string index.

Mysql fetch assoc() is faster because using mysql fetch array() without providing MYSQL ASSOC, MYSQL NUM, or MYSQL BOTH returns two arrays, which are essentially what mysql fetch assoc() and mysql fetch row() would return.

I hope this helps you.