removing data from a shopping cart

amar3d

Hi, Below i have a simple shopping cart(very basic),what i wish to do is have it so that a person can remove an item they dont want, I've tried delete queries but for some reason it deletes all the content...the fields in the cart table are email and dvd_id. if anyone could help me with this it would be much appriciated...thanks in advance.

-AD

<?php session_start();
if(empty($_SESSION['email'])) {
die('Your must be Logged to view this page. <a href=customerlogin.php>login </a>');
}
?>
<html>
<body>
Your Shopping Cart

<?php
$email=$_SESSION['email'];
$db="test";
$link = mysql_connect("localhost");
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());

$query = "SELECT * From cartdvds WHERE email='$email'";
$result = mysql_query($query);

echo "<div align=center><table bordercolor=#000000 border=0 width=100% cellspacing=0>\n";
echo "<tr>
<td width=12% height=41>
</td>
<td width=10%>
</td>
<td width=30%>
</td>
<td width=15%>
</td>
</tr>\n";

while ($row = mysql_fetch_array ($result)) {
$dvd_id=$row['dvd_id'];

$query1 = "SELECT * From dvds WHERE dvd_id='$dvd_id'";
$result1 = mysql_query($query1);

while ($row1 = mysql_fetch_array ($result1)) {
$dvd_name=$row1['dvd_name'];

echo" <tr>
<td > </td>
<td ><img src='{$row1["thumb"]}'></td>
<td >{$row1["dvd_name"]}
{$row1["dvd_price"]}
{$row1["synopsis"]}</td>
<td >remove </td>
</tr>\n\n";
}
}
echo '</table>'
?>
</body>
</html>

dhodge

What is the problem with your delete query? I would have a unique ID for each from in the cartdvds. Granted the email and dvd_id combined are a primary key (likely) it would require that you pass both values to delete an item. I would do something like this...

if ($GET["delete"])
{
$query = "DELETE FROM cartdvds WHERE Primary_Key_Name = ".$GET["delete"]
}

you could print your list so that

...
<a href="$PHP_SELF?delete=$key">Remove</a>
...