Subversion-Projekte lars-tiefland.content-management

<?
function getOptions($itemId) {
        global $database;
        
        $buffer=array();
        $query="
                SELECT
                        $database.Features.ID as featureID,
                        $database.Features.Name as featureName,
                        $database.Feature_options.Value as optionName,
                        $database.Feature_options.ID as optionValue
                FROM
                        $database.Feature_options,
                        $database.Feature_to_Ware,
                        $database.Features
                WHERE
                        $database.Feature_options.Feature = Features.ID
                AND
                        $database.Feature_to_Ware.Feature = Features.ID
                AND
                        1 << $database.Feature_options.bit & $database.Feature_to_Ware.Feature_options > 0
                AND
                        $database.Feature_to_Ware.Ware = $itemId
                AND
                        $database.Features.Language = 'DE'
                AND
                        $database.Features.Sonderoption = 0
                AND
                        $database.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;
}
?>