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];

}

What is mvc php?

937

---

What is the difference between query and question?

965

---

How do you end a session in php?

1085

---

Is array function in php?

1022

---

Does facebook use php framework?

1018

---

Where can I find php ini file?

961

---

How many escape sequences are recognized in single-quoted strings?

928

---

What is the use of strip_tags() method?

936

---

What does the function get_magic_quotes_gpc() means?

935

---

Is jquery better than javascript?

983

---

Who is the father of php and what is the current version of php and mysql?

1326

---

Is python similar to php?

1029

---

How are php sessions stored?

972

---

How to check if a string contains a character or word in php?

1008

---

Why is overriding runtime?

996

---