Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Explain the difference between static and dynamic websites?

0 Answers  


How can we destroy the cookie?

4 Answers  


Why use static methods php?

0 Answers  


What is the difference between explode () and split () functions in php?

0 Answers  


What is isset function in php?

0 Answers  






What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?

11 Answers   HCL, Rushmore Consultancy, Thursday Technology,


In how many ways we can retrieve the date in the result set of mysql using PHP?

5 Answers   Yahoo,


What is interface? Why it is used?

0 Answers  


What is json php?

0 Answers  


What is member variable?

0 Answers  


Tell me what are the correct and the most two common way to start and finish a php block of code?

0 Answers  


What is a procedure in php?

5 Answers   Wipro,






Categories