what is the difference between mysql_fetch_array() and
mysql_fetch_row()?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How many ways are there for passing variables between pages in PHP and what are they ?
How many bootable file in O/S - XP,2000, and 98. which are the files.
What is php destruct?
Can we run php in apache tomcat?
How can you retrieve a cookie value?
What is the use of array_count_values() in php?
How can I make a script that can be bilingual (supports english, german)?
What is user defined function in php?
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?
Require_once(), require(), include(). What is difference between them?
Where sessions stored in PHP?