delete problem

Anon

I'm new with PHP. I have a problem with delete function.
Everytime i delete a data from database I have to refresh to see the result. So how to solve this problem? And is dividing all the function(add, delete, update) in separated file can overcome this?
Any help would be very grateful.
Thank you.

(delete function)
if(empty($userid)) error_message('Empty User ID!');

$link_id = db_connect($default_dbname);
if(!$link_id) error_message(sql_error());

//*******SQLstmt-delete chosen data*****

$query = "DELETE FROM $user_tablename WHERE userid = '$userid'";
$result = mysql_query($query);
if(!$result) error_message(sql_error());

$num_rows = mysql_affected_rows($link_id);
if($num_rows != 1) error_message("No such user: $userid");

user_message("All records regarding $userid have been delete!");
php_databases@p2p.wrox.com

html>

<body>

badman

looks like there is some setting change in your browser, if you are using internet explorer do the following:
go tools- intenet options , select the tab named general, in that click on settings button located in temporary internet files group, in that you will see a number of options, select the topmost(every visit to page)

i think it shud work fine.
anyway, once the page is loaded with some data from tables and data is changed in the tables after this,you will have to refresh to see the changes(i hope this is not what your problem was!!!).How else wud browser know that data has changed.....

cheers!

noeffred

i've encountered this problem quite often and usually overcame it by inserting this piece of html in the <head> area of the page (this way the page will always be loaded new from the server)

worked fine with me