what is the difference between mysql_fetch_array() and
mysql_fetch_row()?
Answer Posted / deepaa
There is not so much difference between the
mysql_fetch_array and mysql_fetch_assoc in the sense that
both can fullfill your requirements but it depends on your
need and ease of use. I prefer mysql_fetch_array because
with it i can use both indexed value and associative value.
I will explain this difference with short example:
$sql = mysql_fetch_array(‘select name, address from
tbl_customer’);
It means that you are getting answer directly into an array
, and you dont need to know the field value of the elements
to be outputed.
Just print the output as:
foreach($sql as $ans){
echo $ans[0].' lives in '.$ans[1];
}
or
foreach($sql as $ans){
echo $ans['name'].' lives in '.$ans['address'];
}
mysql_fetch_assoc, you can output the result as $ans['name']
but not $ans[0] . What i want say is you need to know about
the field name of the table. Ok here is the sample code:
foreach($sql as $ans){
echo $ans['name'].' lives in '.$ans['address'];
}
But not
foreach($sql as $ans){
echo $ans[0].' lives in '.$ans[1];
}
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can you associate a variable with a session?
how to detect a mobile device using php
Explain what is the difference between session and cookie?
What are different types of errors available in Php?
Tell me how can we define a variable accessible in functions of a php script?
What is singleton class in php?
Explain Booleans in PHP?
What is session cookies php?
What is the interface in php?
What is the use of callback in php?
How To Get the Uploaded File Information in the Receiving Script?
What is the difference between session_unregister() and session_unset()?
What are the differences between session and cookie?
What is the difference between Session and Cookie?
Is age a variable in research?