chamilo / chamilo-lms

                    blogs_rel_user.blog_id = '" . (int)$blog_id."'";

        $result = Database::query($sql);

        $blog_members = array ();

        while ($user = Database::fetch_array($result)) {

            $blog_members[$user['user_id']] = api_get_person_name(

                $user['firstname'],

                $user['lastname']

            );

        }

        $result = Database::query($sql);

        $options = array();

        while ($user = Database::fetch_array($result)) {

            $options[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']);

        }

        // Get tasks in this blog / make select list of it

        $sql = "

        $rs = Database::query($sql);

        if (Database::num_rows($rs) > 0) {

            while ($row = Database::fetch_array($rs)) {

                $completeName = api_get_person_name($row['firstname'], $row['lastname']);

                $coaches[] = $row + ['full_name' => $completeName];

            }

            return $coaches;

        } else {

        while ($list_users = Database::fetch_array($res)) {

            $result = Database::query("SELECT * FROM " . Database::get_main_table(TABLE_MAIN_USER) . "

                    WHERE user_id=" . $list_users['user_id']);

            while ($row_user = Database::fetch_array($result)) {

                $name_teacher = api_get_person_name($row_user['firstname'], $row_user['lastname']);

                $list[] = array($row_user['email'] => $name_teacher);

            }

        }

        return $list;

    }

            $sql_query .= " LIMIT $limit_from, $limit_to";

        }

        $sql_result = Database::query($sql_query);

        while ($result = Database::fetch_array($sql_result)) {

            $result['complete_name'] = api_get_person_name($result['firstname'], $result['lastname']);

            $return_array[] = $result;

        }

        return $return_array;

    }

            $sql_query .= ' ORDER BY '.Database::escape_string(implode(',', $order_by), null, false);

        }

        $sql_result = Database::query($sql_query);

        while ($result = Database::fetch_array($sql_result)) {

            $result['complete_name'] = api_get_person_name(

                $result['firstname'],

                $result['lastname']

            );

            $return_array[] = $result;

        }

        return $return_array;

    }