Subversion-Projekte lars-tiefland.content-management

<?
        function getShops($erfassung = NULL)
        {
                $buffer = array();
                $query = array();
                
                $query[] = "select ID, Name from shops";

                if (isset($erfassung))
                {
                        $query[] = "where";
                        $query[] = "erfassung = '$erfassung'";
                }

                $query[] = "order by ID";
                        
                $result = mysql_query(implode(" ",$query)) or die (mysql_errno().": ".mysql_error().pre($query,true));
                
                while($r = mysql_fetch_array($result))
                {
                        $buffer[$r["ID"]] = $r["Name"];
                }
                return $buffer;
        }
?>