difference between mysql_fetch_assoc and mysql_fetch_array

[sanjay123456]

Dear friends ,


Plz any one tell me What is difference between mysql_fetch_assoc and mysql_fetch_array while both are return associtive array ?

[jx2]

Dear friends ,


Plz any one tell me What is difference between mysql_fetch_assoc and mysql_fetch_array while both are return associtive array ?

mysql_fetch_array will return twice as much data!! and doesnt work well if you use foreach();
simply try it for each of them!!
[php]
foreach($yourArray as $k =>$v){
echo "$k => $v <br>";
}
[/php]

jx2

[Lumpy]

Straight from the php website...

mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both

mysql_fetch_assoc — Fetch a result row as an associative array

I think what this is saying is that mysql_fetch_array can be used like...

$row['fieldname'] 
or
$row[0]
 

where mysql_fetch_assoc can only be used like...

$row['fieldname']
 

hope this helps.

[tolkienarda]

mysql fetch array function allows for two inputs the first is the result reasource, this is the only required field but you can enter what kind of array you would like, the default is MYSQL_BOTH which means it works as either kind of array or you can tell it to only use numbers or associative keys, the mysql fetch assoc function is the same as mysql fetch array with the MYSQL_ASSOC option.

http://us2.php.net/manual/en/function.mysql-fetch-array.php
http://us2.php.net/mysql_fetch_assoc

the manual for php is very useful and easy to read


eric bressler