header redirecton problem

[civey]

i am using the following code and i keep getting


<?
session_start();
include("dbblsr.php");

mysql_select_db("cgowie_teamcanada", $conn);

$result = mysql_query("SELECT * FROM teamcanada WHERE reqemail='$_POST[reqemail]'");
$row = mysql_fetch_array($result);
$pass = $row['password'];
$rights = $row['useright'];
$name = $row['reqfirst'];
$email =$row['reqemail'];

IF ($pass != md5($_POST['password'])){
("Incorrect password.");
header( 'Location: loginca.php' ) ;
}
ELSE{
$_SESSION['access']= $_SESSION['access']+1;
$_SESSION['rights']= $rights;
$_SESSION['reqfirst']= $name;
$_SESSION['reqemail']= $email;
header( 'Location: team_canada.php' ) ;

}
?>
keep getting an error saying something along the lines of:

Warning: Cannot add header information - headers already sent by (output started at

etc. etc. etc.

Could somebody please tell me what I need to do differently?

[scragar]

that error means that you have content before your headers/sessions, possibly a space or something before quotes or some such...

and read my sig:

[civey]

I use the same code on a different page with a headers and it worked fine the only thing i change was the db and the headers

[civey]

I use the same code and just change the table that i check and it works fine. I am new to this can some help. Do i need to have the password and userid located at a certain poition in the sql table?

[TheRave]

Its nothing to do with the password and userid in the table.

The error is related to these lines:

header( 'Location: loginca.php' ) ;
//snip
header( 'Location: team_canada.php' ) ; 

There must NOT be any kind of output before these lines. There must be NO content (including whitespace) outside of your PHP tags before these lines.

Try attaching your code files as well as the whole error. It might make it easier for us.

[MrCoder]

Add this at the very top of your code..

ob_start(); 

[civey]

Thanks it worked. Can you tell me what that line of code does

[TheRave]

Normally php outputs during processing, so the starts receiving the page while the script is still running.

The ob functions control buffering of output. With ob started php outputs everything to a buffer. Only when the php has finished processing (or if the buffer is explicitly flushed) does the user start receiving the page.

The added code means that your header calls (which aren't buffered) are being sent to the client before they receive any output.

[civey]

With that code it does go to header location but it does not check the db and it does not execute the else statement

[TheRave]

With the ob started it will still execute all the code.

[civey]

That is not happening for me

[civey]

This is what the code looks like now when i execute it displays the header for the incorret password but when i input a user email and password it redisplays the same thing.
<?
ob_start();
session_start();
include("dbblsr.php");

mysql_select_db("cgowie_teamcanada", $conn);

$result = mysql_query("SELECT * FROM teamcanada WHERE reqemail='$_POST[reqemail]'");
$row = mysql_fetch_array($result);
$pass = $row['password'];
$rights = $row['useright'];
$name = $row['reqfirst'];
$email =$row['reqemail'];

IF ($pass != md5($_POST['password'])){
("Incorrect password.");
header( 'Location: loginca.php' ) ;
}
ELSE{
$_SESSION['access']= $_SESSION['access']+1;
$_SESSION['rights']= $rights;
$_SESSION['reqfirst']= $name;
$_SESSION['reqemail']= $email;
header( 'Location: team_canada.php' ) ;

}
?>

Then i try this notice that it has a different db and this db does not include the table i am trying to check but it still got to the incorrect header location
<?
ob_start();
session_start();
include("db.php");

mysql_select_db("cgowie_teamcanada", $conn);

$result = mysql_query("SELECT * FROM teamcanada WHERE reqemail='$_POST[reqemail]'");
$row = mysql_fetch_array($result);
$pass = $row['password'];
$rights = $row['useright'];
$name = $row['reqfirst'];
$email =$row['reqemail'];

IF ($pass != md5($_POST['password'])){
("Incorrect password.");
header( 'Location: loginca.php' ) ;
}
ELSE{
$_SESSION['access']= $_SESSION['access']+1;
$_SESSION['rights']= $rights;
$_SESSION['reqfirst']= $name;
$_SESSION['reqemail']= $email;
header( 'Location: team_canada.php' ) ;

}
?>

[civey]

any ideas

[scragar]

you still havn't used the forums [php] and [/php] tags around your code, which means that it's far harder to spot errors, so I'm gonna wait for that, like I waited for you to do it earlier with your first post.

http://www.webdeveloper.com/forum/sh...68&postcount=5 <-- read!

[civey]

This is all php code

<?php
ob_start();
session_start();
include("dbblsr.php");

mysql_select_db("cgowie_teamcanada", $conn);

$result = mysql_query("SELECT * FROM teamcanada WHERE reqemail='$_POST[reqemail]'");
$row = mysql_fetch_array($result);
$pass = $row['password'];
$rights = $row['useright'];
$name = $row['reqfirst'];
$email =$row['reqemail'];

IF ($pass != md5($_POST['password'])){
("Incorrect password.");
header( 'Location: loginca.php' ) ;
}
ELSE{
$_SESSION['access']= $_SESSION['access']+1;
$_SESSION['rights']= $rights;
$_SESSION['reqfirst']= $name;
$_SESSION['reqemail']= $email;
header( 'Location: team_canada.php' ) ;

}
?>