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
Can age be a variable?
What does $this do in php?
How do you destroy a session?
Why do we use interface in php?
Does php have a future?
How long will it take to learn php?
How to remove values saved in the current session?
How to repeat a string to a specific number of times in php?
How to get complete current page url in php?
What is ltrim?
What is the use of $_server and $_env?
Where do we use get and post?
How do I see how many pages per session in google analytics?
Explain how to submit form without a submit button.
What are php errors?