<% include("../cmsbk/dk_config.php"); include("../cmsbk/dk_browsercheck.inc.php"); if ($left) $left = (int)$left; else $left = 0; $q = "SELECT count(*) FROM kunst WHERE destination = 5"; $res = mysql_query($q); $row = mysql_fetch_row($res); $max=$row[0]; $q = "SELECT * FROM kunst WHERE destination = 5 ORDER BY display_order"; $res = mysql_query($q); $row = mysql_fetch_row($res); for ($x = 0; $x < $left; $x++) $row = mysql_fetch_row($res); if ($max - $left < 10) $right = $max - $left; else $right = 10; // START OBJECT CODE // /* $left6 = $left + 6; $q1 = "SELECT count(*) FROM kunst WHERE destination = 4 AND display_order >= $left AND display_order < $left6"; $res1 = mysql_query($q1); $row1 = mysql_fetch_row($res1); $max_obj=$row1[0]; if ($max_obj > 0) { $q2 = "SELECT * FROM kunst WHERE destination = 4 AND display_order >= $left AND display_order < $left6"; $res2 = mysql_query($q2); $row_obj = mysql_fetch_row($res2); } */ // END OBJECT CODE // %> Stockmenu

SBK
Deze week in de virtuele opslag:

<% for ($x = 0; $x < $right; $x++) { echo "$row[2]\n"; if($row[1]) { echo "\n"; } $row = mysql_fetch_row($res); echo "
"; } /* echo "
"; if ($row_obj <> "") { echo "Objecten: "; for ($x = 0; $x < $max_obj; $x++) { echo "
$row_obj[2]\n"; if($row_obj[1]) { echo "\n"; } $row_obj = mysql_fetch_row($res2); } }*/ %>

<% if ($max - $left > 10) { $left += 10; echo "Meer stock...

"; } else echo " "; %>

overzicht opslag

opslag stellingen:
<% for ($x = 0; $x < ($max / 10); $x++) { $xl = $x * 10; $xz = $x + 1; echo "$xz"; if ($x < ($max/10 -1)) echo " | "; } %>

Exposities:
<% $q = "select count(*) from kunst where destination = 1"; $res = mysql_query($q); $row = mysql_fetch_row($res); $max=$row[0]; for ($x = 0; $x < ($max / 5); $x++) { $xl = $x * 5; $xz = $x + 1; echo "$xz"; if ($x < ($max/5 -1)) echo " | "; } %>

uitleenzalen:
<% $q = "select count(*) FROM kunst WHERE destination = 2"; $res = mysql_query($q); $row = mysql_fetch_row($res); $max=$row[0]; for ($x = 0; $x < ($max / 5); $x++) { $xl = $x * 5; $xz = $x + 1; echo "$xz"; if ($x < ($max/5 -1)) echo " | "; } %>

Collectiezalen:
<% $q = "select count(*) from kunst where destination = 3"; $res = mysql_query($q); $row = mysql_fetch_row($res); $max=$row[0]; for ($x = 0; $x < ($max / 5); $x++) { $xl = $x * 5; $xz = $x + 1; echo "$xz"; if ($x < ($max/5 -1)) echo " | "; } %>


entree  |  home