Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	include_once("/web/apache/mediaran.de/preisagent/transfer/connect.php");
3 
 
4 
	/* -------------------- OPTIONEN LADEN START -------------------- */
5 
 
6 
	$query="
7 
			SELECT
8 
				Features.Name,
9 
				Feature_options.Bit,
10 
				Feature_options.Value,
11 
				Feature_options.Feature
12 
			FROM
13 
				Features,
14 
				Feature_options
15 
			WHERE
16 
				Features.Language='DE'
17 
			AND
18 
				Feature_options.Feature=Features.ID
19 
			ORDER BY
20 
				Feature_options.Bit
21 
	";
22 
 
23 
	$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
24 
	$__Features = array();
25 
	$__Feature_ID_from_Name = array();
26 
	while($Feature=mysql_fetch_assoc($result))
27 
	{
28 
		$__Feature_ID_from_Name[$Feature[Name]]=$Feature[Feature];
29 
		$__Features[$Feature[Name]][$Feature[Bit]]=$Feature[Value];
30 
	}
31 
 
32 
	/* -------------------- OPTIONEN LADEN ENDE -------------------- */
33 
 
34 
	/* -------------------- VERKNÜPFUNGEN LADEN START -------------------- */
35 
 
36 
	$query="
37 
			SELECT
38 
				Ware,
39 
				Feature,
40 
				Feature_options
41 
			FROM
42 
				Feature_to_Ware
43 
	";
44 
 
45 
	$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
46 
	$__Feature_to_Ware = array();
47 
	while($zeile=mysql_fetch_assoc($result))
48 
	{
49 
		$__Feature_to_Ware[$zeile[Ware]][$zeile[Feature]]=$zeile[Feature_options];
50 
	}
51 
 
52 
	/* -------------------- VERKNÜPFUNGEN LADEN ENDE -------------------- */
53 
 
54 
?>