Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	function getOptions($itemId)
3 
	{
4 
		$buffer=array();
5 
		$query="
6 
			SELECT
7 
				Features.ID as featureID,
8 
				Features.Name as featureName,
9 
				Feature_options.Value as optionName,
10 
				Feature_options.ID as optionValue
11 
			FROM
12 
				Feature_options,
13 
				Feature_to_Ware,
14 
				Features
15 
			WHERE
16 
				Feature_options.Feature = Features.ID
17 
			AND
18 
				Feature_to_Ware.Feature = Features.ID
19 
			AND
20 
				1 << Feature_options.bit & Feature_to_Ware.Feature_options > 0
21 
			AND
22 
				Feature_to_Ware.Ware = $itemId
23 
			AND
24 
				Features.Language = '".$_SESSION['INI']['language']."'
25 
			AND
26 
				Features.Sonderoption = 0
27 
			AND
28 
				Features.Einzeloption = 0
29 
			";
30 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
31 
		while($zeile=mysql_fetch_assoc($result))
32 
		{
33 
			if (!$buffer[$zeile['featureID']])
34 
			{
35 
				$buffer[$zeile['featureID']] = array
36 
				(
37 
					"featureID"		=>	$zeile['featureID'],
38 
					"featureName"	=>	$zeile['featureName'],
39 
					"options"		=>	array()
40 
				);
41 
			}
42 
			$buffer
43 
			[$zeile['featureID']]
44 
			['options']
45 
			[$zeile['optionValue']]
46 
			=
47 
			array
48 
			(
49 
				"optionValue"	=>	$zeile['optionValue'],
50 
				"optionName"	=>	$zeile['optionName']
51 
			);
52 
		}
53 
		return $buffer;
54 
	}
55 
?>