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