what is the difference between mysql_fetch_array() and
mysql_fetch_row()?
Answer Posted / sekhar
mysql_fetch_array($resultset, [return type]);
return a row from the result set as an array
return type values:
MYSQL_NUM If return type is mysql_num, we have to use the
column position in the result set.
MYSQL_ASSOC: if return type is mysql_assoc, we have to fetch
the data by using column names in result set.
MYSQL_BOTH: if return type is mysql_both, we have to fetch
the data by using column index or column names in the result
set.
mysql_fetch_rows($resultset);
retrives the row from the result set and move the pointer to
the next record.
we have to retrive the data from the row by using the filed
position in the result set.
mysql_fetch_assoc($resultset);
retrives a row from the resultset as an associative array.
we have to retrive the data by using the columns name in the
result set.
mysql_fetch_object($resultset);
return the row as an object. we have to fetch the data in
the row fetch the column names in the result set as $row->
column name in the result set.
| Is This Answer Correct ? | 11 Yes | 10 No |
Post New Answer View All Answers
Does php need a closing tag?
How to get length of an array in PHP?
Can a trait extend a class php?
Tell me what does the array operator '===' means?
What is the main difference between asp net and php?
How to read a file in php?
Explain php parameterized functions.
my english is not too good then what we apply for a php programer post
What is framework? How it works? What is advantage?
What is a static variable in php?
How to insert a line break in php string?
Which php global variable is used for uploading a file?
What is the different between count() and sizeof() in php?
Does php use html?
What are php string functions?