Delete Query

[Anon]

I am having trouble, I'm tryint to delete but not happening.

Error in query delete Cart, CartDetail from Cart, CartDetail where Cart.CartID=CartDetail.CartID and Cart.UserID='131' and Cart.CartID='25' You have an error in your SQL syntax near 'Cart, CartDetail from Cart, CartDetail where Cart.CartID=CartDetail.CartID and C' at line 1

here my query

$query="delete Cart, CartDetail from Cart, CartDetail where Cart.CartID=CartDetail.CartID and Cart.UserID='$UserID' and Cart.CartID='$retrieve' ";

[Anon]

try this:

$query="DELETE FROM Cart C,
CartDetail CD
WHERE C.CartID = CD.CartID
AND C.UserID = '$UserID'
AND C.CartID = '$retrieve'";

don't think you can specify specific fileds in a table while using the DELETE statement.
if you just what to set the fields ti NULL or something then use UNDATE instead.

hope this works..

[Anon]

Your query should be:
delete from cart, cartdetail where cart.cartid=cartdetail.cartid and cart.userid='$userid' and cart.cartid='$retrieve'

This is because you delete at least one whole record from a table with the DELETE instruction, not columns.

HTH
Steven