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 / srinivas1982

sorry for my mistake. here is the answer
the functions mysql_fetch_row(), mysql_fetch_array() and
mysql_fetch_object() return one row from the result, and
then move the pointer on. If there are no more rows to
fetch, it returns false. This means you can you use a very
simple while loop:

$result=mysql_query("SELECT * FROM sometable");
while($row=mysql_fetch_row($result)){
do_something_with_row();
}

This will automatically terminate when the last row has been
processed.

the difference between mysql_fetch_row() and
mysql_fetch_array() is that the first returns the results in
a numeric array ($row[0], $row[1] etc), while the latter
returns a the results an array containing both numeric and
associative keys ($row["name"], $row["email"] etc).
mysql_fetch_object() returns an object ($row->name,
$row->email etc).

Is This Answer Correct ?    60 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which function would you use to insert a record into a database in php?

1045


What is encapsulation in php?

981


How to turn on the session support?

1095


What is a null coalescing operator in php7?

1157


What is stdclass in php?

958


Write a program to find a string is palindrome or not?

962


Explain what are the three classes of errors that can occur in php?

973


What is the function to count elements in an array in PHP?

1095


How to create a session? How to set a value in session?

986


How to display your correct URL of the current web page?

1105


Is strcmp case sensitive?

963


What is the use of curl()?

1067


Is array empty php?

916


How values in arrays are indexed?

1059


Is runtime polymorphism overriding?

1005