Subversion-Projekte lars-tiefland.content-management

<?
/* 
 * getUsers()
 * holt alle User für diese Site aus der Accesstabelle
 */
        function getUsers()
        {
                global $localhost_dbh, $site;

                $query="
                                SELECT
                                        ID,
                                        user as username
                                FROM
                                        content_management.Access
                                WHERE
                                        ID > 0
                                AND
                                        user like '%@$site'
                                ORDER BY user
                        ";
/*
                $query="
                                SELECT
                                        ID,
                                        user as username
                                FROM
                                        content_management.Access
                                WHERE
                                        user = 'admin'
                                OR
                                        user like '%@$site'
                                ORDER BY user
                        ";
*/
                $result = mysql_query ($query, $localhost_dbh) or die (mysql_errno().": ".mysql_error());

                $buffer=array();
                while ($zeile = mysql_fetch_assoc($result))
                {
                        $buffer[$zeile[ID]] = $zeile[username];
                }

                return $buffer;
        }
?>