I don't think those variables are readable in the function. Not totally
sure though.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
----- Original Message -----
From: "Patrick Hartnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 10:02 PM
Subject: [PHP] MySQL Connection Error - mysql_select_db
> here is a function used to authenticate users against mysql database.
> Problem is, I am not connecting for some reason. I have the db variables:
> $db_host
> $db_user
> $db_pass
> $db_name
>
> They are populated from an include ("x.php") in the beginning of the php
> section. It is getting past the connect statement, but it is not
selecting
> the proper database, and gives a:
>
> "Error in query: No Database Selected"
>
> in the error trap below (die). Any ideas what is wrong? Am I missing
some
> syntax, or what?
> Thanks.
>
> Patrick
>
> ######################################
>
> function authenticate($user, $pass)
> {
>
> // check login and password
> // connect and execute query
> $connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable
> to connect!");
> $query = "SELECT id from users WHERE username = '$user' AND password =
> PASSWORD('$pass')";
> mysql_select_db($db_name);
> //mysql_select_db("devweb"); <--what it should be, from file
> $result = mysql_query($query, $connection) or die ("Error in query: " .
> mysql_error());
>
> // if row exists -> user/pass combination is correct
> if (mysql_num_rows($result) == 1)
> {
> return 1;
> }
> // user/pass combination is wrong
> else
> {
> return 0;
> }
> }
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
