Mysql_fetch_array returns duplicate data

Question

every time I run mysql_fetch_array, the array is returned with duplicate values , e.g.

Array
(
    [0] => 1
    [row_id] => 1
    [1] => some text
    [first_field] => some text
    [2] => some text
    [second_field] => some text 
}

but I only need individual results in the array, I tried to use

mysql_fetch_array($data, MYSQL_ASSOC);

But it does not matter.

+5

mk_89 Aug 14 '12 at 17:22

6 answers

mysql_fetch_array , , . mysql_fetch_assoc. mysql_fetch_row.

+3

Rubin Porwal 14 . '12 18:36

mysql_fetch_assoc() mysql_fetch_row

+1

Clarence 14 . '12 17:25

, , FALSE, . , result_type. MYSQL_BOTH ( ), .. MYSQL_ASSOC, ( mysql_fetch_assoc() ), MYSQL_NUM, ( mysql_fetch_row() ).

, MYSQL_BOTH , . MYSQL_ASSOC MYSQL_NUM, . mysql_fetch_assoc(), .

0

j08691 14 . '12 17:25

mysql_fetch_array() , ( , ), (.. 0 - , 1, ..). .

, mysql_fetch_assoc() , mysqli, , , mysql_ *.

0

Mike Brant Aug 14 '12 at 17:26

mysqli_fetch_array($result, MYSQL_ASSOC)this worked for me, as suggested above for mysql_fetch_assoc, in PHP5.5 it is deprecated now.

0

rohit mandiwal Feb 21 '16 at 11:07

newfurniturey · Accepted Answer · 2012-08-14T17:25:03+0000

This is the assigned functionality mysql_fetch_array(). If you want to not have "duplicates" and just have an associative array, use mysql_fetch_assoc().

Example:

while ($row = mysql_fetch_assoc($data)) { ... }