I am developing an e-commerce, of which I have two main tables:
pd_cart
pd_order_status
I tried removing the following:
mysqli_query($this->conexao,"DELETE S FROM pd_order_status S
INNER JOIN pd_cart C
ON S.status_cart_token = C.cart_token
WHERE S.status_date < NOW()
AND S.status_order = 'A';")
But it is only excluded from the pd_order_status table and not from the pd_cart. How can i fix this?
Adding the missing table in the delete:
It probably won't delete you because you have a foreign key defined.