Single record delete query

chrislead

Hmmmm,

I have a list of records on my page selected from the mysql database. they are displayed through a loop where each record has a 'Remove' text link next to them.

I want to be able to remove individual items in this list, but the appropriate record is deleted.

I have set up a function on the same page that is called through the text link; 'Remove'. I then tried this query:

function remove(){
mysql_query("DELETE FROM cart WHERE session_id = '".$_COOKIE[PHPSESSID]."' AND plu = '".$row['plu']."'");
display();

But it doesn't work, I figured I needed to include these 2 parameters to only delete the relevant product, but any help is much appreciated as to how to get this to work, and delete only the specific record that the 'Remove' button is associated with.

Hope I have made myself clear. Thanks.

zhabala

Post your code here, then we can help you. Otherwise it has no sense.

Zdenek

chrislead

Sorry:

From the previous page, I posted (through a form) information which collected on this page using this:

	$quantity = $_POST['quantity']; 
	$plu = $_POST['plu']; 
	$description = $_POST['description'];
	$price = $_POST['price'];
	$type = $_POST['type'];
	$sessionid = $_POST['sessionid'];

$_SESSION['quantity'] = $quantity; 
$_SESSION['plu'] = $plu; 
$_SESSION['description'] = $description; 
$_SESSION['price'] = $price; 
$_SESSION['type'] = $type;
$_SESSION['sessionid'] = $sessionid;

These values are then inputted into the mysql database(successfully).

The contents of this database holding the inormation above is displayed in a table; one item per row using a loop function.

I have a text link with the following hyperlink next to each item displayed in a row of my table:

<a href="shopping_basket.php?action=remove&plu=<? $row['plu']; ?>">Remove</a>

...which calls the case here:

case 'remove':
remove();
break;

...diverting to the function:

function remove($plu){
	mysql_query("DELETE FROM cart WHERE session_id = '".$_COOKIE[PHPSESSID]."' AND plu = '".$plu."'");
	display();	
}

I basically want to delete a record from the database, but according to the item. It possibly might be the relating to the record that I am having trouble doing.

Hope this is clearer.

zhabala

You have to check, whether it is going into that remove() function. You can check it with some echo statement in there. Then assure that the session_id in DB is the same as $_COOKIE['PHPSESSID'].

And do not forget to call the remove() with proper parameter ( $plu .... now it is missing in your code )

Zdenek

chrislead

I managed to solve the problem, I simply transferred my function onto a separate page, and then posted for the second time the plu in a hidden field. I then recalled the data from the session and displayed as appropriate.

Thanks for your help though.