Which should I use: mysql_fetch_array or mysql_fetch_assoc?

Question

In other people's code I see both being used. So when retrieving database records, which should be used and when?

E.Benoît · Accepted Answer · 2011-03-13 18:20:46Z

3

mysql_fetch_array() is more generic than mysql_fetch_assoc(), although it can generate the exact same results using proper parameters.

However, if you only need an associative array, I would advise you to use the latter, as the former makes the code more ambiguous or heavy, depending on how you use it.

answered Mar 13, 2011 at 18:20

E.Benoît

8067 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felix Dransfeld · Accepted Answer · 2011-03-14 00:32:11Z

1

just a note:

there are some other functions to get the results of your query like:

mysql_fetch_row and
mysql_fetch_object

Felix

answered Mar 14, 2011 at 0:32

Felix Dransfeld

2,7371 gold badge31 silver badges41 bronze badges

Collectives™ on Stack Overflow

Which should I use: mysql_fetch_array or mysql_fetch_assoc?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related