$itemnr=$_GET['itemnr'];
$actie=$_GET['actie'];
function showerror()
{
die("Error " . mysql_errno() . " : " . mysql_error());
}
$servnhost="localhost";
$servname="santaswint_db";
$servpass="W2sW99gEt";
$servdb="santaswint_db";
if(!($connection = @ mysql_connect("$servnhost","$servname","$servpass")))
die("Failed to connect to the server. Script terminated.");
if(!mysql_select_db("$servdb", $connection))
showerror();
if(!($sql = @mysql_query("SELECT * FROM Lemax2012 where ItemNumber = '$itemnr' ORDER BY ItemNumber ASC")))
showerror();
while ($list = mysql_fetch_object($sql))
{
$cat="".$list->ItemCategorie."";
if($cat!=""){
if(!($sqlcat = @mysql_query("SELECT * FROM Categorie WHERE `ID` ='$cat'")))
showerror();
while ($listcat = mysql_fetch_object($sqlcat))
{
$catname="".$listcat->Name."";
}
}
$pagename="".$list->ItemName." | Item ".$list->ItemNumber." |".$catname." | Lemax";
$pagekeywords="".$list->ItemName.", Item, ".$list->ItemNumber.", ".$catname.", Lemax,";
include('header.php');
if($actie=='bezit'){
if(!($sqltry = @mysql_query("
UPDATE `Lemax2012` SET
`ItemBezit` = '1'
WHERE
`ItemNumber` = '".$list->ItemNumber."'
")))
showerror();
echo"Toegevoegd aan de bezit lijst. ".$list->ItemNumber."";
}else if($actie=='besteld'){
if(!($sqltry = @mysql_query("
UPDATE `Lemax2012` SET
`ItemBezit` = '2'
WHERE
`ItemNumber` = '".$list->ItemNumber."'
")))
showerror();
echo"Toegevoegd aan de Besteld lijst. ".$list->ItemNumber."";
}else if($actie=='nietbezit'){
if(!($sqltry = @mysql_query("
UPDATE `Lemax2012` SET
`ItemBezit` = '0'
WHERE
`ItemNumber` = '".$list->ItemNumber."'
")))
showerror();
echo"Het item is niet meer in bezit. ".$list->ItemNumber."";
} else if($actie=='dell'){
if(!($sqltry = @mysql_query("
UPDATE `Lemax2012` SET
`ItemBezit` = '4'
WHERE
`ItemNumber` = '".$list->ItemNumber."'
")))
showerror();
echo"Toegevoegd aan de niet gewild lijst. ".$list->ItemNumber."";
}
?>
}
include('footer.php');
?>