Please Help, I created this script as part of my shopping cart system the script is not suppossed to echo the results of the database, but was supposed to update another table with the result, each time i run it, it redirects to the page I specified but when ever I open the database to look into the content of the table PHP is supposed to update its always empty, Please help
my script is below
?php
//Start a session
session_start();
//create short variable name
$var = $_GET['var'];
//connect to database
$session = mysql_connect("localhost", "root", "platinum")or die(mysql_error());
if (!$session)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db("xplosive")or die(mysql_error());
if ($var == "ALP2004"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'ALP2004'";
}
else if($var == "GLD2000"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'GLD2000'";
}
else if($var == "THK200"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'THK2000'";
}
else if($var == "BRA2003"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'BRA2003'";
}
else if($var == "DEA2001"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'DEA2001'";
}
else if($var == "GRD2003"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'GRD2003'";
}
else if($var == "OSJ2001"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'OSJ2001'";
}
else if($var == "DOD2004"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'DOD2004'";
}
else if($var == "JRC2001"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'JRC2001'";
}
else if($var == "REE2002"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'REE2002'";
}
else if($var == "CRE2003"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'CRE2003'";
}
else if($var == "MTX1999"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'MTX1999'";
}
else if($var == "MNR2002"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'MNR2002'";
}
else if($var == "MTX2003"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'MTX2003'";
}
else if($var == "MTX2004"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'MTX2004'";
}
else if($var == "SPD2004"){
$query ="select Title, Cat_No, Price
from movies
where Cat_No = 'SPD2004'";
}
else if($var == "CDDL2003"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'CDDL2003'";
}
else if($var == "GDST2001"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'GDST2001'";
}
else if($var == "CDLG1995"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'CDLG1995'";
}
else if($var == "CDNT2003"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'CDNT2003'";
}
else if($var == "REST2002"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'REST2002'";
}
else if($var == "SKST2001"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'SKST2001'";
}
else if($var == "CDSA2001"){
$query ="select Title, Cat_No, Price
from music
where Cat_No = 'CDSA2001'";
}
//add info into cart
$addtocart = "insert into cart values
('', '$PHPSESSID', 'Title', 'Cat_No, 'Price', now())";
mysql_query($addtocart);
//redirect to showcart page
header("Location: showcart.php");
exit;
?>
