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
Is php a mvc?
How to call javascript function in php without any event?
How to convert a string to uppercase in php?
What is difference between core php and framework?
What does $_server means?
Explain me what are the 3 scope levels available in php and how would you define them?
What are the different types of array in php?
Explain mysql_error().
What are PHP Magic Methods/Functions. List them.
What type of headers that PHP supports?
Could we start a variable with number like $4name?
Tell me how is it possible to know the number of rows returned in result set?
How can I convert ereg expressions to preg in php?
What is meant by variable variables in php?
What is the use of "enctype" attribute in a html form?