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;

}

?>