Fetch array function doubling values in each position of array?

Question

I am getting strange behaviour from this function.

Input

    public function fetch_array($result_set) 
{
        $rows = array();
        while ($row = mysql_fetch_array($result_set)) 
        {
            $rows[] = $row;
            print_r($row);
            break;
        }
        return $rows;

}

I have made the function run once but it its duplicating a row from my MySQL query result.

Output

Array ( [0] => Sarah [first_name] => Sarah [1] => Palin [second_name] => Palin )

It should be

Correct Output

Array ( [first_name] => Sarah [second_name] => Palin )

I used this SO question example

Use mysql_fetch_array() with foreach() instead of while()

Not my query or Mysql result fault

https://i.sstatic.net/icUYI.png

enter image description here

What is going wrong here?

The $rows array is exactly the same as the $row array returned from mysql_fetch_array. So why not just return $row after you fetched it? On a side note: don't use the mysql_ functions. They will soon be removed from PHP. And use mysql_fetch_assoc instead of mysql_fetch_array. — w00
– w00, Commented Oct 16, 2012 at 19:25
technically it isn't the same, it is an array containing the $row array, but your point is valid. — user1726343
– user1726343, Commented Oct 16, 2012 at 19:36

Brian Glaz · Accepted Answer · 2012-10-16 19:22:03Z

4

This is not an error, it's the intended behavior of mysql_fetch_array() http://us.php.net/manual/en/function.mysql-fetch-array.php

You can either set the result_type flag, or you can just use mysql_fetch_assoc() instead. http://us.php.net/manual/en/function.mysql-fetch-assoc.php

answered Oct 16, 2012 at 19:22

Brian Glaz

15.7k4 gold badges40 silver badges55 bronze badges

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

1 Comment

Brian Glaz Over a year ago

Sure, just replace $row = mysql_fetch_array($result_set) with $row = mysql_fetch_assoc($result_set)

score 2 · Accepted Answer · 2012-10-16 19:30:30Z

2

When using mysql_fetch_array, feed it the MYSQL_ASSOC flag.

EDIT: Here's your code, with the appropriate change

while ($row = mysql_fetch_array($result_set, MYSQL_ASSOC))

Also, you can get them with just the numeric indices by feeding it MYSQL_NUM

edited Oct 16, 2012 at 19:30

answered Oct 16, 2012 at 19:20

user1726343

Comments

CaptainCarl · Accepted Answer · 2012-10-16 19:21:46Z

1

The reason why you get one result and wanting the other is because you are pushing an array($row) inside a new array ($rows). By pushing something in an array(The brackets you use) you get an auto incrementing key with it.

answered Oct 16, 2012 at 19:21

CaptainCarl

3,4996 gold badges42 silver badges74 bronze badges

Comments

jcho360 · Accepted Answer · 2012-10-16 19:22:12Z

1

try this:

$rows['name'] = $row['name'];
$rows['second_name] = $row['second_name'];

...

instead of

$rows[] = $row;

answered Oct 16, 2012 at 19:22

jcho360

3,7491 gold badge18 silver badges25 bronze badges

1 Comment

tomaytotomato Over a year ago

Thanks, however if I am wanting to use this function with other data I dont think this would work

Community · Accepted Answer · 2023-11-20 22:45:59Z

1

By default mysql_fetch_array has two keys for each database column -- one with the numerical key and one with the associative key. You can do this to tell it only to fetch the numeric keys:

mysql_fetch_array($result, MYSQL_NUM);

https://www.php.net/manual/en/function.mysql-fetch-array.php

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Oct 16, 2012 at 19:24

Chris Carson

1,84515 silver badges14 bronze badges

Comments

davidkonrad · Accepted Answer · 2012-10-16 19:25:41Z

1

It is completely normal and expected behaviour. If you just want the associative array, use

while ($row = mysql_fetch_array($result_set, MYSQL_ASSOC))

answered Oct 16, 2012 at 19:25

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Collectives™ on Stack Overflow

Fetch array function doubling values in each position of array?

6 Answers 6

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related