mysql_fetch_array returns duplicate data

Question

every time i run mysql_fetch_array an 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 want single results in the array, I have tried using

mysql_fetch_array($data, MYSQL_ASSOC);

But this makes no difference.

Please don't use the mysql extension anymore! It's better to use PDO or MySQLi. — ComFreek
– ComFreek, Commented Aug 14, 2012 at 17:25
@ComFreek this is a private app that only I will use, for now its not a big problem using mysql but when I have time i'll change to MySqlLi — mk_89
– mk_89, Commented Aug 14, 2012 at 17:28
@mk_89: you didn't post your query and table structure. Hard to give accurate answers without that. — Jocelyn
– Jocelyn, Commented Aug 14, 2012 at 17:42
with actual PDO, use $row = $streq->fetch(PDO::FETCH_ASSOC) — bcag2
– bcag2, Commented Jul 27, 2023 at 13:22

newfurniturey · Accepted Answer · 2012-08-14 17:25:03Z

15

This is the intended functionality of mysql_fetch_array(). If you want to not have the "duplicates" and just have the associative-array, use mysql_fetch_assoc() instead.

Example:

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

answered Aug 14, 2012 at 17:25

newfurniturey

38.6k10 gold badges99 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jocelyn Over a year ago

mysql_fetch_array($data, MYSQL_ASSOC); will do exactly the same as mysql_fetch_assoc.

newfurniturey Over a year ago

@Jocelyn I am aware of that - however - there is no way using MYSQL_ASSOC would return an array with the output the OP displayed, as per the manual.

newfurniturey Over a year ago

@mk_89 I just tested with mysql_fetch_array($data, MYSQL_ASSOC) and cannot replicate (i.e. - it's working how it should) so I cannot answer as to why it would fail in your case. Try using mysql_fetch_assoc() and see if that resolves the issue.

Rubin Porwal · Accepted Answer · 2012-08-14 18:36:42Z

5

mysql_fetch_array returns resultset returned as as response to query execution as both associative and numeric arrays. For returning resultset as associative array you need to use mysql_fetch_assoc function. For returning resultset as numeric array you need to use mysql_fetch_row function.

answered Aug 14, 2012 at 18:36

Rubin Porwal

3,8451 gold badge27 silver badges27 bronze badges

Comments

Clarence · Accepted Answer · 2012-08-14 17:25:13Z

1

Use mysql_fetch_assoc() for associtive array, or mysql_fetch_row for a numeric array

answered Aug 14, 2012 at 17:25

Clarence

2,96220 silver badges16 bronze badges

1 Comment

Jocelyn Over a year ago

mysql_fetch_array($data, MYSQL_ASSOC); will do exactly the same as mysql_fetch_assoc.

Mike Brant · Accepted Answer · 2012-08-14 17:26:38Z

1

mysql_fetch_array() returns an array containing both associative keys (the field names specified by queries) and integer position key (i.e. 0 is first field, 1, is second, etc.). This is for convenience in accessing the data by either method.

if you only want the named keys, you should use mysql_fetch_assoc() or better yet, use the mysqli functions as everyone on here will lambast you for using the old mysql_* functions.

answered Aug 14, 2012 at 17:26

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

2 Comments

Jocelyn Over a year ago

mysql_fetch_array($data, MYSQL_ASSOC); will do exactly the same as mysql_fetch_assoc.

Mike Brant Over a year ago

@Jocelyn Yes it will. I don't understand the downvote though, as most developer who were familiar with using the old mysql_* functions for any period of time would typically use mysql_fetch_assoc and not have to worry about setting the proper flag on the function call.

Rohit Mandiwal · Accepted Answer · 2016-02-21 11:07:25Z

1

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

answered Feb 21, 2016 at 11:07

Rohit Mandiwal

10.5k5 gold badges75 silver badges89 bronze badges

Comments

j08691 · Accepted Answer · 2012-08-14 17:25:13Z

0

From the manual:

Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined. By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).

In other words, since MYSQL_BOTH is the default, you get both back. You can specify either MYSQL_ASSOC or MYSQL_NUM instead to get an associative array or numeric array back. You could also use mysql_fetch_assoc() instead which will only return an associative array.

answered Aug 14, 2012 at 17:25

j08691

208k33 gold badges269 silver badges281 bronze badges

Comments

mariston · Accepted Answer · 2019-02-17 19:57:54Z

0

The mysql_fetch_array() returns indexed as well as associative array. However mysql_fetch_assoc() returns only associative-array.

When mysql_fetch_array used with MYSQLI_NUM parameter returns only an indexed array. Example: mysql_fetch_array($resultset,MYSQLI_NUM)

answered Feb 17, 2019 at 19:57

mariston

1

Collectives™ on Stack Overflow

mysql_fetch_array returns duplicate data

7 Answers 7

3 Comments

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related