what is the difference between mysql_fetch_array() and
mysql_fetch_row()?

Answers were Sorted based on User's Feedback



what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / guru

Mysql_fetch_array():
Mysql_fetch_array() returns row as an associative, numeric array or both based on parameters passed in it. Three types of parameters can be passed in mysql_fetch_array function.

1. MYSQL_BOTH - return both associative and numeric array
2. MYSQL_ASSOC - return associative array
3. MYSQL_NUM - return numeric array
Reference:http://www.phponwebsites.com/2014/03/php-mysql-fetch-array.html
Mysql_fetch_row():
It return row as numeric array. We can't use associative indices to retrieve data from mysql table using php.
Reference: http://www.phponwebsites.com/2014/03/php-mysql-fetch-row.html

Is This Answer Correct ?    0 Yes 0 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / tushal burungale

fetch_array:
fetch_array returns result in assoc array and also in
numeric array
e.g fetch_array:Array([0]=>Tushal)

fetch_row:
mysql_fetch_row returns result in numeric array only.
e.g
fetch_row:Array([0]=>Tushal[name]=>Tushal)

Is This Answer Correct ?    0 Yes 0 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / narasimha.p

mysql_fetch_array()works as an associative array i.e. just
use the field name specified in your database to access the
values while mysql_fetch_row() returns the value of a
single field in a particular row if you r going to specify
the array's index which starts from '0'.

Is This Answer Correct ?    0 Yes 1 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / aditya

sql_database
singsingle field in a particular row if you r going to specifyle field in a particular row if you r going to specify
is it correct answer????????????????????

Is This Answer Correct ?    0 Yes 1 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / manikandan

mysql_fetch_array()works as an associative array i.e. just
use the field name specified in your database to access the
values while mysql_fetch_row() returns the value of a
single field in a particular row if you r going to specify
the array's index which starts from '0'.

Is This Answer Correct ?    4 Yes 6 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / jemit p jose

mysql_fetch_row() for select aggragate data or single data
eg:select count(*) from TableName

mysql_fetch_array() for retrive more data from Table

Is This Answer Correct ?    42 Yes 53 No

what is the difference between mysql_fetch_array() and mysql_fetch_row()?..

Answer / srinivas1982

Wrong mysql_fetch_row retrives a single row or record from a
table and mysql_fetch_array returns all rows and result into
an array this array is both numeric and associative.

mysql_fetch_row has single row.
where as mysql_fetch_array has multiple rows.

Is This Answer Correct ?    25 Yes 42 No

Post New Answer

More PHP Interview Questions

How many ways are there for passing variables between pages in PHP and what are they ?

10 Answers  


How many bootable file in O/S - XP,2000, and 98. which are the files.

1 Answers   IBM,


What is php destruct?

0 Answers  


Can we run php in apache tomcat?

0 Answers  


How can you retrieve a cookie value?

0 Answers  






What is the use of array_count_values() in php?

0 Answers  


How can I make a script that can be bilingual (supports english, german)?

0 Answers  


What is user defined function in php?

0 Answers  


How can I find the width and height of an image resource?

2 Answers   Rushmore Consultancy,


What is difference between action hook and filter hook?

0 Answers  


Require_once(), require(), include(). What is difference between them?

0 Answers  


Where sessions stored in PHP?

0 Answers  


Categories