What is the difference between mysql_fetch_array and
mysql_fetch_object?
Answers were Sorted based on User's Feedback
Answer / subrat
mysql_fetch_array ? Fetch a result row as an associative
ARRAY, a numeric array, or both
mysql_fetch_object ? Fetch a result row as an OBJECT
| Is This Answer Correct ? | 25 Yes | 2 No |
Answer / sumit
mysql_fetch_object : will return the results from database
as objects. fields will be accessible like an objects
i.e $result->name
mysql_fetch_array : will return the results from database as
array. fields will be accessible like in objects
i.e $result[name]
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / jeevabala
mysql_fetch_array : fetch the result as an array
mysql_fetch_object : fetch the result as a object
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhay kumar
mysql_fetch_array display all matching record from table as
an array while mysql_fetch_object dispaly first matching
from table as ab object
| Is This Answer Correct ? | 6 Yes | 9 No |
What is mysql routine?
Does mysql use tcp or udp?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What are the other commands to know the structure of table using MySQL commands except explain command?
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
How can an index be declared in mysql?
What's the latest version of mysql?
What is the use of mysqli_connect in php?
What is difference between statement and preparedstatement?
What is database clustering in mysql?
Does mysql scale well?
How to install mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)