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
What is the use of extract function in php?
How to convert a character to an ascii value?
How to execute a function in php?
What is htaccess? Why do we use this and where?
How be the result set of mysql handled in php?
What is use of in_array() function in php?
What is a php form?
Where can I find php ini file?
What is the timeout period on session values?
What is the function func_num_args() used for?
Which is incorrect with respect to separating php code and html?
What is the function file_get_contents() usefull for?
How to call a php function from html button?
What is the use of strpos in php?
What are the advantages of indexes in php?