Changing the array return of php/mysql function

Question

I have this get_all function:

function get_all($query)
{
    $res = mysql_query($query);
    $arr_res = array();
    while($row = mysql_fetch_array($res))
        $arr_res[] = $row;
    mysql_free_result($res);

    return $arr_res;
}

It returns this array of data, which is what I need, but I don't want the first item of each array "[0]" to be returned with it:

   Array
    (
        [0] => Array
            (
                [0] => gallery-1-1310312288_logo.jpg
                [post_image] => gallery-1-1310312288_logo.jpg
            )

    )

How can I alter the function to drop this extra item?

Dan Smith · Accepted Answer · 2011-07-10 16:06:10Z

4

Change this line:

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

By default mysql_fetch_array will return the numerical array index and the associative one - adding the second parameter will make the function only return the associate index.

answered Jul 10, 2011 at 16:06

Dan Smith

5,67534 silver badges33 bronze badges

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

1 Comment

prodigitalson Over a year ago

or you can use explicitly mysql_fetch_assoc which essentially does the same thing.

Collectives™ on Stack Overflow

Changing the array return of php/mysql function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related