Autorization error

[Anon]

Why does this script gives an Internet Error (500)?

<?php

// File Name: log-in.php3

$auth = false; // Assume user is not authenticated

if (isset( $PHP_AUTH_USER ) && isset( $PHP_AUTH_PW))
{
	include "../../php_functions/mysql.inc";
	$sql = "select * from users where Username='$PHP_AUTH_USER' and Password='$PHP_AUTH_PW'"; 
	$result = mysql_db_query($DB, $sql, $Connection); 
	$num = mysql_num_rows($result); 

	if ( $num != 0 )
	{
		$auth = true;
	}
}

if (!$auth)
{
	header ('WWW-Authenticate: Basic realm="Private"');
	header ('HTTP/1.0 401 Unauthorized');
	exit;
}
else
{
	header ('Location: http://www.bla.nl/index.html');
	echo 'Autorization succeeded.';
}

?>

Thanks in advance!

Patrick

[Anon]

Hi.

Read this (from the manual): "Remember that the Header() function must be called before any actual output is sent either by normal HTML tags or from PHP. It is a very common error to read code with include() or with auto_prepend and have spaces or empty lines in this code that force output before header() is called. "

Try to delete all blank lines.

[Anon]

I have found that you cant use Header() functions and .htaccess files at the same time. One or the other. (at least on Win32)