Glansbeek.

CATALOGUS

"; $br = 0; $kat = mysql_fetch_array(mysql_query("SELECT kategorija FROM kategorija WHERE id = $id")); $subkat = mysql_fetch_array(mysql_query("SELECT name FROM podkat WHERE id = $subid")); $selement = mysql_query("SELECT * FROM element WHERE kat = '$kat[0]' AND podkat = '$subkat[0]' ORDER BY ime") or die("Error in expression"); while ($element = mysql_fetch_array($selement)) { echo ""; $br++; if ($br == 3) { echo ""; $br = 0; } } echo "


$kat[1] "; if ($kat[0] == $id) { $skatname = mysql_query("SELECT * FROM kategorija WHERE id=$id") or die ("Error in expression"); $katname = mysql_fetch_array($skatname); $ssubcat = mysql_query("SELECT * FROM podkat WHERE kat = '$katname[1]'"); while ($subcat = mysql_fetch_array($ssubcat)) { echo "$subcat[0] "; } } } if (!@$subid) {} else { $selected = true; } ?>
$element[1]

"; } else { $selement = mysql_query("SELECT * FROM element WHERE id = $elid"); while ($element = mysql_fetch_row($selement)) { echo "

$element[6]

$element[5]

< Back

$element[1]

$element[2]

"; if ($element[3] !== NULL and $element[4] !== "") { echo "

$element[4]

"; } echo "

"; echo "

"; echo ""; $x = 0; $ssubel = mysql_query("SELECT * FROM subelement WHERE element = '$element[1]'"); while ($subel = mysql_fetch_row($ssubel)) { if ($x==0) { echo ""; if ($subel[2] !== "NULL" and $subel[2] !== "") { echo ""; } if ($subel[3] !== "NULL" and $subel[3] !== "") { echo ""; } if ($subel[4] !== "NULL" and $subel[4] !== "") { echo ""; } if ($subel[9] !== "NULL" and $subel[9] !== "") { echo ""; } if ($subel[6] !== "NULL" and $subel[6] !== "") { echo ""; } if ($subel[5] !== "NULL" and $subel[5] !== "") { echo ""; } if ($subel[7] !== "NULL" and $subel[7] !== "") { echo ""; } if ($subel[8] !== "NULL" and $subel[8] !== "") { echo ""; } echo ""; $x++; } echo ""; if ($subel[2] !== "NULL" and $subel[2] !== "") { echo ""; } if ($subel[3] !== "NULL" and $subel[3] !== "") { echo ""; } if ($subel[4] !== "NULL" and $subel[4] !== "") { echo ""; } if ($subel[9] !== "NULL" and $subel[9] !== "") { echo ""; } if ($subel[6] !== "NULL" and $subel[6] !== "") { echo ""; } if ($subel[5] !== "NULL" and $subel[5] !== "") { echo ""; } if ($subel[7] !== "NULL" and $subel[7] !== "") { echo ""; } if ($subel[8] !== "NULL" and $subel[8] !== "") { echo ""; } echo ""; } echo "

Artikelnr.	Omschrijving	Uitvoering	Lengte	Kleur	Aansluiting	VE	Prijs
$subel[2]	$subel[3]	$subel[4]	$subel[9]	$subel[6]	$subel[5]	$subel[7]	$subel[8]

"; } } } ?>