Page doesn't reload after redirect. Please help

[coldscooter]

Hi, I have a PHP page that displays a table of records, pulled from a MySQL database.

Each record has a delete link that directs to another PHP page that runs the code to delete that record from the DB. It then redirects back to the original page with the table.

My problem is that the page then needs to be manually refreshed to show that the record has been deleted. It seems it's just displaying the cached version rather than reloading the page.

Does anyone know how I can fix this?

[aj_nsc]

Hmmm...maybe this will help:

http://ca3.php.net/header

Scroll down to the part on caching directives.

[coldscooter]

I'm affraid i can't really use that thread to help me with my problem. All i want is to be able to redirect to another page and make sure that that page loads from fresh rather than cache. Surely there is a simple function... ?

Any help would be greatly appreciated.

[OctoberWind]

I'm affraid i can't really use that thread to help me with my problem. All i want is to be able to redirect to another page and make sure that that page loads from fresh rather than cache. Surely there is a simple function... ?

Any help would be greatly appreciated.

I'm sorry, but I think that's exactly what you need.

Example #2 Caching directives

PHP scripts often generate dynamic content that must not be cached by the client browser 
or any proxy caches between the server and the client browser. 
Many proxies and clients can be forced to disable caching with:

<?php
// add this to the top of your page with the database records
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
?>

[coldscooter]

Hi, Sorry i didn't mean to sound ungrateful for the help. But this code does not redirect anywhere. Would i just add: header("location:http:www.test.com"); under these statements?

[OctoberWind]

What is the script doing to delete the record?

Each record has a delete link that directs to another PHP page that runs the code to delete that record from the DB. It then redirects back to the original page with the table.

The Cache-control goes on the "original" page to force the content to reload on every page load.

[coldscooter]

Excellent. Thanks for your help. That worked a treat.