redirect user after email is found in SQL DB

[hey_suburbia]

Here is what I have:

[code]<?php


mysql_connect("localhost","user","pass");


mysql_select_db("db");

$email = $_POST['email'];
 
$fetch_exist=mysql_query("SELECT email FROM db WHERE email = '$email'");

if(mysql_num_rows($fetch_exist)>0)
{
header('Location: www.site.com/page1.html');
exit;
}

else
{
$error_message .="
That Email is not in our database. \n
Please register here: www.site.com/page2.html
";
die ($error_message);
}

?>[/code]


The problem occurs when I try to redirect with "Location:", I get:

Warning: Cannot modify header information - headers already sent by (output started at /usr/com/site/public_html/login.php:3) in /usr/com/site/public_html/login.php on line 23


Line 23 is the header('Location: http://www.site.com');

Normally this is fixed by just making the only content the "Location:" script, but I have to access the database first?

[b]In a nutshell:[/b]
If email exists, user goes to page1.html.
If email doesn't exist, user goes to page2.html

Thanks!

[bltesar]

perhaps you have some blank spaces/lines following the final '?>'

any such spaces/lines are sent as HTML and will cause the error you see

[hey_suburbia]

WOW.

That worked...

I would have never thought.

I had an extra line after the "p>".

Thanks