';
echo " ";
//for($i=0; $i< count($headcat_array); $i++){
for($i=0; $i< 4; $i++){
$dbsql = "select categorie_id, titel from categorie where hoofd_categorie_id = ".$headcat_array[$i][0]." order by titel";
$dbconn = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable");
mysql_select_db($dbname,$dbconn) or die("Database Unavailable");
$result = mysql_query($dbsql);
$iRows = mysql_num_rows($result);
$tot_rows = $tot_rows + $iRows;
$iCols = mysql_num_fields($result);
settype($subcat_array,"array");
for($row=0 ; $row<$iRows; $row++){
$rs = mysql_fetch_row($result);
for($col=0; $col<$iCols; $col++){
$subcat_array[$row][$col] = $rs[$col];
};
};
mysql_free_result($result);
mysql_close($dbconn);
echo " ";
echo '
';
echo ' ";
echo ' ';
echo ' | | ';
echo "
";
echo "
";
echo '
';
for($j=0; $j< count($subcat_array); $j++){
echo ' ';
echo ' | | ';
//$href = $subcat_array[$j][0].'_'.str_replace(" ", "_", $subcat_array[$j][1]).'.php';
$href = "navigate.php?cat_id=".$subcat_array[$j][0];
echo ' '.$subcat_array[$j][1].' | ';
echo "
";
};
$subcat_array=$empty_array;
echo "
";
echo "
";
};
echo "
';
echo " ";
//aktie popartiesten
echo " ";
echo '
';
echo ' ";
echo ' ';
echo ' | | ';
echo "
";
echo "
";
echo '
';
echo ' ';
echo ' | | ';
$href = "britney_spears.php";
$artist = "Britney Spears";
echo ' '.$artist.' | ';
echo "
";
echo ' ';
echo ' | | ';
$href = "jennifer_lopez.php";
$artist = "Jennifer Lopez";
echo ' '.$artist.' | ';
echo "
";
echo ' ';
echo ' | | ';
$href = "pamela_anderson.php";
$artist = "Pamela Anderson";
echo ' '.$artist.' | ';
echo "
";
echo ' ';
echo ' | | ';
$href = "paris_hilton.php";
$artist = "Paris Hilton";
echo ' '.$artist.' | ';
echo "
";
echo "
";
echo "
";
//for($i=0; $i< count($headcat_array); $i++){
for($i=4; $i< 10; $i++){
$dbsql = "select categorie_id, titel from categorie where hoofd_categorie_id = ".$headcat_array[$i][0]." order by titel";
$dbconn = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable");
mysql_select_db($dbname,$dbconn) or die("Database Unavailable");
$result = mysql_query($dbsql);
$iRows = mysql_num_rows($result);
$tot_rows = $tot_rows + $iRows;
$iCols = mysql_num_fields($result);
settype($subcat_array,"array");
for($row=0 ; $row<$iRows; $row++){
$rs = mysql_fetch_row($result);
for($col=0; $col<$iCols; $col++){
$subcat_array[$row][$col] = $rs[$col];
};
};
mysql_free_result($result);
mysql_close($dbconn);
echo " ";
echo '
';
echo ' ";
echo ' ';
echo ' | | ';
echo "
";
echo "
";
echo '
';
for($j=0; $j< count($subcat_array); $j++){
echo ' ';
echo ' | | ';
//$href = $subcat_array[$j][0].'_'.str_replace(" ", "_", $subcat_array[$j][1]).'.php';
$href = "navigate.php?cat_id=".$subcat_array[$j][0];
echo ' '.$subcat_array[$j][1].' | ';
echo "
";
};
$subcat_array=$empty_array;
echo "
";
echo "
";
};
echo "
';
echo " ";
//for($i=0; $i< count($headcat_array); $i++){
for($i=10; $i< 16; $i++){
$dbsql = "select categorie_id, titel from categorie where hoofd_categorie_id = ".$headcat_array[$i][0]." order by titel";
$dbconn = mysql_connect($dbhost,$dbuserlogin,$dbpassword) or die("Server Unavailable");
mysql_select_db($dbname,$dbconn) or die("Database Unavailable");
$result = mysql_query($dbsql);
$iRows = mysql_num_rows($result);
$tot_rows = $tot_rows + $iRows;
$iCols = mysql_num_fields($result);
settype($subcat_array,"array");
for($row=0 ; $row<$iRows; $row++){
$rs = mysql_fetch_row($result);
for($col=0; $col<$iCols; $col++){
$subcat_array[$row][$col] = $rs[$col];
};
};
mysql_free_result($result);
mysql_close($dbconn);
echo " ";
echo '
';
echo ' ";
echo ' ';
echo ' | | ';
echo "
";
echo "
";
echo '
';
for($j=0; $j< count($subcat_array); $j++){
echo ' ';
echo ' | | ';
//$href = $subcat_array[$j][0].'_'.str_replace(" ", "_", $subcat_array[$j][1]).'.php';
$href = "navigate.php?cat_id=".$subcat_array[$j][0];
echo ' '.$subcat_array[$j][1].' | ';
echo "
";
};
$subcat_array=$empty_array;
echo "
";
echo "
";
};
echo "
