I'm using this as a log on but it gives me this warning message:

Warning: Supplied argument is not a valid MySQL resource
/httpd/html/php2/login.php on line 27


<? ob_start() ?>
<?php
function access_denied()

Header("WWW-Authenticate: Basic realm=\"$title\"");
Header("HTTP/1.0 401 Unauthorized");
}

function auth_headers($title)

Header("WWW-Authenticate: Basic realm=\"$title\"");
Header("HTTP/1.0 401 Unauthorized");
}
if(!isset($PHP_AUTH_USER))

auth_headers("Members Area");
access_denied();
exit;
}
else {

$db_hostname = "localhost"; // database host, usually "localhost"
$db_username = "contact"; // username for the database (make sure it has
proper privledges)
$db_password = "cdi986"; // password that cooresponds to DB USERNAME
$db_database = "contact_informations"; // what database is your member info
stored in?

$query = "SELECT username,password FROM contact_informations WHERE
username='$PHP_AUTH_USER' AND password='$PHP_AUTH_PW'";
$link = mysql_connect($db_hostname, $db_username, $db_password) or
die("Unable to connect to database server");

if (mysql_num_rows(mysql_db_query($db_database, $query)) == 0)

auth_headers("Members Area");
access_denied();
exit;
}

mysql_close($link);
}
?>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to