Jump to content


Photo

redirect user after email is found in SQL DB


  • Please log in to reply
2 replies to this topic

#1 hey_suburbia

hey_suburbia
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts

Posted 02 August 2006 - 08:13 PM

Here is what I have:

<?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);
	}

?>


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?

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

Thanks!

#2 bltesar

bltesar
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts

Posted 02 August 2006 - 08:22 PM

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

#3 hey_suburbia

hey_suburbia
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts

Posted 02 August 2006 - 08:30 PM

WOW.

That worked...

I would have never thought.

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

Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users