[Resolved] problem with redirecting based on login

[squilbert]

Hi everyone
I'm having quite a few problems trying to get my login script working so that it redirects the user to a page depending on what interest they have chosen. Their interests are held in a mysql database. The most anoyying thing with this is that everytime I try to login, after I submit a correct username and password, it just displays a blank page!
Here is the bit of code causing me the problem:
$count = mysql_num_rows($result);

if ($count > 0)
{
echo "Welcome $username<br>";
update_login_table($username);
login_page();
$login = "yes";

}
else
{
echo "Your username or password is invalid. Please try again.";
}

function login_page()
{
$username = $_POST[UserName];

$host="localhost";
$connect = mysql_connect($host,"","")
or die ("Couldn't connect to server.");

$db = mysql_select_db("liveweb", $connect)
or die ("Couldn't connect to database.");

$sql1 = "SELECT InterestsID FROM customer_interests WHERE UserName = '$username'";
$query1 = mysql_query ($sql1)
or die ("Couldn't execute query.".mysql_error());

//foreach ($HTTP_POST_VARS as $key => $value)

$row = mysql_fetch_array($query1);
extract($row);

$interest = array[InterestID];
if ($interest == 1);
{
header ("Location: mylivedrama.php");
}
else if ($interest == 5);
{
header ("Location: mylivejhc.php");
}
else
{
header ("Location: whatson.php");
}
return;
}
I've been trying to get this to work for a couple of days now and now have no idea what I'm doing wrong.
Any suggestions anyone?
Thanks in advance.

[drew010]

i think its coming up blank because you have a parse error. on your if's and elseif's you dont want to put a semicolon at the end of the line.
i.e.
if ($interest == 1);
{
header ("Location: mylivedrama.php");
}
else if ($interest == 5);
...
should be

if ($interest == 1)
{
header ("Location: mylivedrama.php");
}
else if ($interest == 5)
...

[squilbert]

I've tried taking off those semicolons but it still just displays a blank page.
Is there any code I can add that forces php to display any errors?

[sidney]

put

error_reporting(E_ALL);

at the top of script

this will show all errors warnings and notices

[squilbert]

thanks
tried adding that to the top of my script but I STILL get a blank page. It's as if my script does nothing at all now as it doesn't update any of the database tables or even check for valid logins anymore. Yet when this was just a simple login script (before I added the function to redirect users depending on their choices) it worked perfectly.
Is there any settings I need to check/adjust to be able to see these errors?

[sidney]

try that ive tested and displays different pages

you will need o change sql querys as it set for my test server
and remove echos and uncomment headers

 $count = 2; 

if ($count > 0) 
{ 
echo "Welcome $username<br>"; 
//update_login_table($username); 
$login = "yes";
login_page(); 

} 
else 
{ 
echo "Your username or password is invalid. Please try again."; 
} 

function login_page() 
{ 
$username = $_POST['UserName']; 

require("../temp/connect.php");

$sql1 = "SELECT test2 FROM test WHERE name = '$username'"; 
$query1 = mysql_query ($sql1) 
or die ("Couldn't execute query.".mysql_error()); 

//foreach ($HTTP_POST_VARS as $key => $value) 

$row = mysql_fetch_array($query1); 
extract($row); 


if ($test2 == 1) 
{ 
echo"1";
//header ("Location: mylivedrama.php"); 
} 
else if ($test2 == 2) 
{ 
echo"2";
//header ("Location: mylivejhc.php"); 
} 
else 
{
 echo"3";
//header ("Location: whatson.php"); 
} 
return; 
}  

[squilbert]

😃 😃 😃
Many thanks for that.
Its now working perfectly and redirecting to the correct pages.