[RESOLVED] 'Delete' question

[badgoat]

Hello!

I have a table with contacts, and another with events. I am able to add a contact by ID to the event table WQhat I am struggling with is how to delete the contact ID from the event table by clicking a 'Delete' link displayed next to the contact record. I figure that a delete SQL query has to be squeezed into the link below, but I have never done it. Also, the link is within a PHP script. Does anyone have an example to post, or a link to a page that describes what I am trying to do, so I can figure it out on my own?

<a href="<?php echo $PHP_SELF; ?>""a_id='.$row['a_id'].'"> Delete</a>

[devinemke]

the a_id variable will be passed to your script as a GET variable: $GET['a_id']. use that form your delete query.

DELETE FROM table WHERE a_id = $_GET['a_id']

[badgoat]

And that gets sandwiched into the PHP tags in the link, correct?

[devinemke]

badgoat wrote:

And that gets sandwiched into the PHP tags in the link, correct?

no, the link is simply passing the a_id. again, that variable will be passed as a GET variable, which can be used to create your query.

[badgoat]

aah ok, I follow. Thank you!