[Resolved] Error: No Database Selected ??

splendidbob

Hi.
I am having a problem which didnt occur on my local machine but which has appeared when testing remotely on my server..

The database is definately called 'focust' and all other details are correct.. however, the error message being returned is " Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in g:\websites\luminate\htdocs\custwin\test.php on line 23 Error: No Database Selected" I have stared at this for a while trying to figure out how the database hasnt been selected, is there anything stupidly obvious i have missed?


$emailaddress=$_POST['emailaddress'];
$competitor1=$_POST['competitor1'];
$competitor2=$_POST['competitor2'];
$competitor3=$_POST['competitor3'];


$db = mysql_connect("localhost","","");

//problem area:
mysql_select_db("focust",$db);
$sql = "SELECT * FROM focust WHERE EmailAddress='$emailaddress'";
$result = mysql_query($sql)or die('Error: '.mysql_error());

$rows = mysql_num_rows($result);
//end problem

if($rows > 0) 
{
	echo"sorry, that email address already exists in our database. You may either try a  <a href=\"test.htm\">different address</a> or  <a href=\"modify.htm\">modify your details</a>";
	exit;
}
else
 {
//etc etc

thx in advance for any help
bob

devinemke

are those the right connection credentials for your remote host? if so that would highly unusually (partucularly on a shared hosting environment). any way, strip your code down and do a simple test:

<?
mysql_connect('localhost', '', '') or exit(mysql_error));
mysql_select_db('focust') or exit(mysql_error));
?>

splendidbob

aarg. I am stupid. Very stupid 🙂

my head clearly isnt working at the minute..

(i didnt put the actual password username into the post for security reasons..)

anyway cutting it down as u suggested revealed my ludicrous error..

i wont go into details, but suffice to say that wasnt the name of my database :o

I do apologise for wasting your time, really need to get my brain functioning properly 😉

thanks anyway

bob