Dont understand "header"

[vinny199]

Hi,

I don't understand the "header" to redirect to another page.
I have read on this forum that you cannot use it after you have echo / print something.

Is updating the database considering as printing something?

What I am trying to do is once my database has been updated upon query, that I'm redirected to another page.

something like :

mysql_query($query_rsadverts1) or die(mysql_error());
 header( "Location: http://www.mysite.com/list_event_07.php" );

basically, once the query is completed, I'd like to go to "list_event_07.php"
I am getting an error "cannot modify headers, header already sent..."

How do I do that?

Cheers,

Vinny

[suntra]

Well make sure that absolutely no contents is printed before the header() statement. Check that there is nothing before the first <?, it has to be the very two first characters.

Also, you should use something like this :

$resResults = mysql_query($query_rsadverts1);
if($resResultats) {
    header( "Location: http://www.mysite.com/list_event_07.php" ); 
    exit();
} else {
    exit('MySQL query failed: ' . mysql_error());
}

So this way, if there is a MySQL error, it will be printed and the header() won't be executed, otherwise, if there is no error, the header() will be executed.