mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]

by

Note: The use of the mysql_* functions are considered deprecated and you should instead use something that offers better security and more functionality, such as MySQLi or PDO.

What is it?

You are looking for mysql_fetch_assoc, as the name implies it will return an associative array (with the column names as keys and the values as the row values).

What will the different functions return?

All of the mentioned functions will return an array, the differences between them is what values that are being used as keys in the returned object.

  • mysql_fetch_row

    This function will return a row where the values will come in the order as they are defined in the SQL query, and the keys will span from 0 to one less than the number of columns selected.

  • mysql_fetch_assoc

    This function will return a row as an associative array where the column names will be the keys storing corresponding value.

  • mysql_fetch_array

    This function will actually return an array with both the contents of mysql_fetch_rowand mysql_fetch_assoc merged into one. It will both have numeric and string keys which will let you access your data in whatever way you’d find easiest.

    It is recommended to use either _assoc or _row though.

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. SQL split values to multiple rows
  3. Find duplicate records in MySQL
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. MySQL: selecting rows where a column is null
  11. Difference between float and decimal data type
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. Parse date in MySQL
  15. mysql dynamic query in stored procedure
  16. mysql: get record count between two date-time
  17. MySQL Insert Into from one Database in another
  18. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  19. How to select one row randomly taking into account a weight?
  20. auto_increment by group
  21. Composite key as foreign key (sql)
  22. MySQL Select minimum/maximum among two (or more) given values
  23. MySQL: set field default value to other column
  24. CREATE command denied to user？
  25. What is the MAX number if I store int(255) in MySQL?
  26. How to initialize mysql container when created on Kubernetes?
  27. Find duplicates in the same table in MySQL
  28. Auto-increment is not resetting in MySQL
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment