mysql未选择数据库,MYSQL PHP未选择数据库-找不到错误

require_once('etcore.php');

mysql_connect($dburl,$dbuser,$dbpass) or die(mysql_error());

mysql_select_db("rshost") or die(mysql_error());

$username=strtoupper(clean($_POST['username']));

$password=md5($_POST['password']);

$andover = mysql_query("SELECT * FROM users WHERE usernameupper='$username' AND password='$password'") or die(mysql_error().__LINE__);

$numberofthings = mysql_num_rows($andover) or die(mysql_error().__LINE__);

if ($numberofthings = 1) {

$getit=mysql_fetch_array($andover) or die(mysql_error().__LINE__);

$_SESSION['id'] = $getit['id'];

header('Location: index.php');

}

else {

?>

Login:

Incorrect Username and/or Password

Username:

Password:

} ?>

This is the code I am using. Whenever I run the code, I get the error "No database selected" on line 7. Any help would be appreciated. Thanks! BTW: Db user, pass and URL are all in the 'etcore.php' file, so it is not a problem there. I have also tried replacing those variables with strings and get the same error.

解决方案

How about:

mysql_select_db("rshost", mysql_connect($dburl,$dbuser,$dbpass))

or even better:

$handle = mysql_connect($dburl,$dbuser,$dbpass);

mysql_select_db("rshost", $handle);

And maybe for a better knowledge and understanding:

manual page

in the section parameters

so it would be clear why it may OR may not work without using the $handle argument