Welkom op de Lemax Santa's Wonderland fan pagina | ";
$cat=$_GET['cat'];
///WHERE `ItemPrise` != ''
$statquery = "AND`ItemState` != '0'";
if($cat =='bezit'){
$catquery="AND `ItemBezit` = '1' OR `ItemBezit` = '3'";
$tbelrow="Bezit |
";
}
if($cat =='gewild'){
$catquery="AND `ItemBezit` != '1' AND `ItemBezit` != 'ng' AND `NietGewild` != '1' ";
$tbelrow="Opzoek |
";
}
if($cat =='besteld'){
$catquery="AND `ItemBezit` = '4'";
$tbelrow="Besteld |
";
}
if($cat =='verkoop'){
$catquery="AND `ItemBezit` = '3'";
$tbelrow="Verkoop |
";
}
if($cat =='all'){
$catquery="";
$tbelrow="Alles |
";
}
if($cat!=""){
if(!($sqlcat = @mysql_query("SELECT * FROM Categorie WHERE `LinkName` ='$cat'")))
showerror();
while ($listcat = mysql_fetch_object($sqlcat))
{
if($listcat->ID =='10'){
$statquery = "";
}
$catquery="AND `ItemCategorie` ='".$listcat->ID."'";
$tbelrow="".$listcat->Name." |
";
$listcatname="".$listcat->Name."";
}
}
if(!($sql = @mysql_query("SELECT * FROM Lemax2011 WHERE `ItemNumber` != '' $statquery $catquery GROUP BY ItemNumber ORDER BY ItemNumber DESC")))
showerror();
$pagename="".$listcatname."";
$pagekeywords="".$listcatname.",";
include('header.php');
?>
ItemName";
$vervang = array(" ", ",", "!", "%", "#", "?", "\"");
$urlnamecat = str_replace($vervang, "", $urlnamecat);
?>
ItemStatus==1){
echo"";
}elseif($list->ItemStatus==2){
echo"";
}elseif($list->ItemStatus==3){
echo"
|
ItemNumber.""; ?>.jpg" alt="ItemNumber.""; ?>" border="0" />