[SOLVED] Header not working..

[jwwceo]

Hello,

 

I have a page where the header has stopped working. It used to work fine. There is no output before the header tag. Is there maybe an apache setting that disallows header functions?

 

James

 

<?php

include 'library/config.php';
include 'library/opendb.php';
error_reporting(0);


$shirt_id = $_GET['shirt_id'];

if(isset($_POST['delete'])) {

$query = "DELETE from shirts WHERE shirt_id='$shirt_id'";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

mysql_query("DELETE FROM shirtkeywords WHERE shirt_id = '$shirt_id'") or die (mysql_query());
mysql_query("DELETE FROM shirtcolors WHERE shirt_id = '$shirt_id'") or die (mysql_query());


header("Location: http://www.liquidcotton.com/admin");

}

[revraz]

Do you get a header error or does it just not redirect?

[jwwceo]

It just doesn't redirect. It goes back to the same page, but the form is empty. So the delete query is working. It just isn't redirecting.

[revraz]

You have error reporting off.  Try setting it to E_ALL to see what errors out.

[phpQuestioner]

check to see if your code is being completely evaluated from top to bottom - try this:

 

<?php

include 'library/config.php';
include 'library/opendb.php';
error_reporting(0);


$shirt_id = $_GET['shirt_id'];

if(isset($_POST['delete'])) {

$query = "DELETE from shirts WHERE shirt_id='$shirt_id'";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

mysql_query("DELETE FROM shirtkeywords WHERE shirt_id = '$shirt_id'") or die (mysql_query());
mysql_query("DELETE FROM shirtcolors WHERE shirt_id = '$shirt_id'") or die (mysql_query());

header("Location:refresh;url=http://www.liquidcotton.com/admin");
echo "Success - Delete Complete!\n";

}
?>

 

do you see "Success - Delete Complete!"?

[jwwceo]

Yes, the code is being completed. I get the output that the delete was successful, but then the empty form again...

 

 

[revraz]

You have error reporting off.  Try setting it to E_ALL to see what errors out.

[jwwceo]

There was 1 line of incorrectly commented lines in my database connection file. this was counting as output I guess...

 

the error setting showed me where it was.

 

THANKS!!!!