redirect URL

[raouleduke]

I am trying to redirect to a URL after completion of a query update, but it is telling me that Cannot add header information - headers already sent by ...
Here is my code:

if($HOLD=='N'){
$query1 = "UPDATE KEYCAD SET HOLD='N' WHERE RO=$RO";
}else{
$query1 = "UPDATE KEYCAD SET HOLD='Y' WHERE RO=$RO";
}
$result = mysql_query($query1) or die(mysql_error());
if ($query1) { 
    header('Location: URL);
}

Any help appreciated thanks.

[Mordecai]

I don't see why that would give you that error. I do, however, see another error. You are missing your second quote in the header. That shouldn't be what's causing the error, though.

My advice is to check the source code of the error, see what's been printed out.

[Floodboy]

try this instead of "header('Location: URL)" :

print "<meta http-equiv=\"refresh\" content=\"0; URL=yoursite.php\">";

[raouleduke]

Great Idea, thanks alot.

[BlakeMMD]

I used to have the same problem, I usually just make sure that the script ends by using exit; after header().
Also incorrect placement of the PHP code in HTML can cause the same problem.

if($HOLD=='N'){
$query1 = "UPDATE KEYCAD SET HOLD='N' WHERE RO=$RO";
}else{
$query1 = "UPDATE KEYCAD SET HOLD='Y' WHERE RO=$RO";
}
$result = mysql_query($query1) or die(mysql_error());
if ($query1) {
header('Location: URL);
exit;
}