header info

[scumgrief]

This is my code for deleting an entry in my address book database

<?
include("config.php");

// open a connection to the database
$connection = mysql_connect($server, $user, $pass);

// formulate the SQL query - same as above
$query = "DELETE FROM addressbook WHERE id='$id'";

// run the query on the database
$result = mysql_db_query($db,$query ,$connection);

// close connection
mysql_close($connection);

header("Location: address.php?currYear=" . $currYear . "&currMonth=" . $currMonth . "&currDay=" . $currDay);
?>

config.php contains just the server name, user and password info.

I need to use the dates to enter data in my appoinment database.

This is the error that i get:-

Warning: Cannot add header information - headers already sent by (output started at /usr/local/nusphere/apache/nsdocs/deleteadd.php:2) in
/usr/local/nusphere/apache/nsdocs/deleteadd.php on line 18

What does that mean?

The exact same code works to delete entries from my appoinment table. The only difference is the table name and the header location file.😕

another thing that I would like to know is how do i tell the script to automatically delete specific entries in the database after a certain time. Example; 5 days after the appoinment, delete the database entry.

[djg_uk]

Hi,

Usually you only get this error after trying to add a header after the PHP is starting to write something to the user agent. Since your code makes a request for an include, you might try taking this out and placing it in the same file.

On the second subject, you will only be able to delete entries from the database when the PHP is run, and the function really depends on what format you have the time and date entered in the database.

If you've used the UNIX timestamp, it is a simple question of searching for a time value of 5 24 60 * 60 less than the current timestamp, and deleting all corresponding entries. For example:

DELETE FROM addressbook WHERE date < (time() - 432000)

Cheers,

David Grant

[Anon]

You are trying to send a header after PHP has already sent the headers and is starting on the body of the document. You can avoid this by turning on output buffering in your php.ini file or by placing the line

ob_start();

on the top of your file.

Jack

[reagent]

How about

DELETE FROM addressbook
WHERE date <= DATE_SUB(NOW(), INTERVAL 5 DAY)