Subversion-Projekte lars-tiefland.php_share

<?
        function getOptions($itemId)
        {
                $buffer=array();
                $query="
                        SELECT
                                Features.ID as featureID,
                                Features.Name as featureName,
                                Feature_options.Value as optionName,
                                Feature_options.ID as optionValue
                        FROM
                                Feature_options,
                                Feature_to_Ware,
                                Features
                        WHERE
                                Feature_options.Feature = Features.ID
                        AND
                                Feature_to_Ware.Feature = Features.ID
                        AND
                                1 << Feature_options.bit & Feature_to_Ware.Feature_options > 0
                        AND
                                Feature_to_Ware.Ware = $itemId
                        AND
                                Features.Language = '".$_SESSION['INI']['language']."'
                        AND
                                Features.Sonderoption = 0
                        AND
                                Features.Einzeloption = 0
                        ";
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
                while($zeile=mysql_fetch_assoc($result))
                {
                        if (!$buffer[$zeile['featureID']])
                        {
                                $buffer[$zeile['featureID']] = array
                                (
                                        "featureID"             =>      $zeile['featureID'],
                                        "featureName"   =>      $zeile['featureName'],
                                        "options"               =>      array()
                                );
                        }
                        $buffer
                        [$zeile['featureID']]
                        ['options']
                        [$zeile['optionValue']]
                        =
                        array
                        (
                                "optionValue"   =>      $zeile['optionValue'],
                                "optionName"    =>      $zeile['optionName']
                        );
                }
                return $buffer;
        }
?>