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
Require_once(), require(), include(). What is difference between them?
How we can declare variable in php?
Can the value of a constant change during the script's execution?
What are examples of dependent variables?
How can we determine whether a php variable is an instantiated object of a certain class?
What percentage of websites use php?
What is include in php?
What is $_ env in php?
Declare a new variable in php equal to the number 3;
Where php language is used?
Write the statements that are used to connect php with mysql
Is php 7.0 stable?
How do you pass a variable by value in php?
What are the encryption functions in php?
What is the delimiter syntax is PHP's default delimiter syntax