Question: i am trying to create a delete page when the user clicks cancel order, here are my codes.

```
$A = @mysql_query("DELETE * FROM customers      WHERE email=    '{$_REQUEST['email']}'");
$B = @mysql_query("DELETE * FROM order_detail   WHERE orderid=  '{$_REQUEST['orderid']}'");
$C = @mysql_query("DELETE * FROM orders         WHERE `serial`= '{$_REQUEST['serial']}'");

```

that is what i did for the cancel.php

and here is the link that would send parameters to the cancel page.

```
<a href='../../includes/cancel.php?orderid=".$row['orderid']."&serial=".$row['serial']."&email=".$_SESSION['email']."''>CANCEL ORDER</a>

```

I dont know why it wont work. please help. thank you

Answer: 
For Mysql the delete Command hast the syntax:

```
DELETE FROM <table> where ....

```
In SQL using \* symbol is major threat for your self and the app, Secondly I would recomed to implement a system that does not delete data off your DB but changes the state (ie: state: 0 'inactive', 1 'active', 2 'removed') and so on. You just never know when you might need this data that you remove.

Also you use @ in front of your mysql\_query which basically skips all the errors and you just dont know wether the query worked or not and if not why.....

Lastly i would strongly suggest you stop using mysql, it is not suported any more massive thread, check mysqli or PDO at least...

Hope this info helps