How to refresh page every time it is used

[szy1]

Hello,

Im using very basic script to show records form database(mysql)
and link that remove the record.

And the problem is when i click delete link IE show same page
with link 'delete' marked as visited, i can only click one more time
or hit F5 to get actual results.(withou t record that i clicked to remove)

How i can make this script to show actual content immediatly
after i click remove link?

Below is the script

index.php:
[PHP]
$id=$_GET[id];
while($row = mysql_fetch_arr ay($result)){
echo $row[id]." ";
echo $row[name]." ".'<a href=index.php? delete=yes&id=' .$row[id].'>delete</a><BR>';
}

if(!empty($_GET[delete]))
{$sql_delete="D ELETE FROM `table1` WHERE `id` = '$id' LIMIT 1";
$w=mysql_query( $sql_delete);

}[/PHP]

[kovik]

The problem is that you get the data from the database before processing the deletion.

[szy1]

Thank you very much :)