将函数中的MySQL行作为数组返回

Question

I'm trying to create a function to return all of the users in a database as an array. When I print_r the users, I'm getting a multi-dimensional array returned:

Ex:

Array ( [0] => Array ( [0] => Albers [1] => Abbings [2] => Blaine [3] 

Code:

   <?php
        session_start();
        function getActiveUsers() {
            $con = mysql_connect("-","-","-");
            if (!$con)
              {
              die('Could not connect: ' . mysql_error());
              }
            else {
                // connected to database successfully
            }
            mysql_select_db("casemanagers", $con);
            $result = mysql_query('select * from users');
            $arr = array();
            while($row= mysql_fetch_assoc($result)){
                $arr[] = $row['Name'];
            }
            return array ($arr);
        }

        $row = array();
        $row = getActiveUsers();
        print_r($row);

    ?>

Can anyone tell me why this is happening or steps I can take to fix it? Thanks.

Answer 1

It's the return line: you should return $arr not array($arr).

What you did there was to create a new array with $arr as its only element.