I have a form that adds a user to a mysql database table and emails the new information to a address (working).
Now I have a form that is used to delete records from the table but I am unable to get it to email the old users data before it deletes it.
for example if the user deletes the id 45 from the table, an email must be sent saying "A user was deleted from the table: 'Name','Phone','Extension'"
code for the delete.php:
<?php require ("database.php"); ?> <?php $this_Stud_ID =$_REQUEST['id']; // sending query mysql_query("DELETE FROM users WHERE id = '$this_Stud_ID'") or die(mysql_error()); if($_POST['action']) header("Location: index.php"); ?> <form action="<?php echo $_SERVER['php_self'] ?>" method="post"> Enter ID Number :<br><input type="text" name="id"><br /> <br><input type="submit" name="action" value="Delete!"> <br> <br> <h3> <a href="index.php"> Main Menu </a> </h3> </form>