Subversion-Projekte lars-tiefland.php_share

<?
        function getAddOnItems($Id)
        {
                $buffer=array();
                $query="
                                select distinct
                                        artikel.*
                                FROM
                                        artikel,
                                        shop_link_table
                                WHERE
                                        shop_link_table.Father = $Id
                                AND
                                        artikel.ID = shop_link_table.ID
                                AND
                                        shop_link_table.Verwendung ='a2a'
                                AND
                                        artikel.Language = '".$_SESSION['INI']['language']."'
                                AND
                                        artikel.status = 0
                                ORDER BY
                                        Father,
                                        rang
                        ";
                        
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
                while($zeile=mysql_fetch_assoc($result))
                {
                        $buffer[]=itemKorrektur($zeile);
                }
                return $buffer;
        }
?>