Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to write in a file in php?

1058


Does php have future?

1023


How many open modes available when a file open in PHP?

1212


What is static in php?

1084


Which function is used in php to count the total number of rows returned by any query?

1077


What is use of mysqli_query in php?

993


How do you find the length of a string in php?

1043


what is the current salary package in India for a PHP programmer who has 1.5 years experience

3030


How does php server work?

1078


What is php default argument?

1078


How to check a key exist in an array?

1139


What is the latest version of php?

1092


What is session and why do we use it?

1107


Is php still in demand?

1090


Explain Booleans in PHP?

1130