Invalid query: No Database Selected...

ComputerNerd888

Hi,

I am getting an error message when trying to write to a database. This is the error message:

Invalid query: No Database Selected

This is my code:

//Make Data Base Connection
$sql  = "INSERT INTO ptest VALUES (4, 'Andrew Balmos', 'ComputerNerd8888@cox.net', 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)";
$conn = mysql_connect('mysql.secureserver.net', 'pte********', '*******');
         mysql_select_db('ptest', $conn);
//Create a Query
$result = mysql_query($sql, $conn) or die("Invalid query: " . mysql_error());


if ($results == FALSE){
print "<FONT face = arial color = red><h3>A Error with storing your test scores into a database has occurred please select back button and Re-Submit the test.</h3></FONT><br>";
        $error = 1;
};

Do you see anything bad.. I have called mysql_select_db('ptest', $conn);... What else do I need to do... I try to add USE ptest to the database SQL but it would error off... Either way I don't care but please help me... Also is there any error in the SQL code?

Thanks,
Andrew

steadyguy

Not sure that it will make much of a difference, but the mysql_select_db(), and mysql_query() functions don't strictly NEED the resource handler, since there's only one. Have you tried it without those arguments? Like I said, I don't see that it'd make much of a difference ... but the only other thing I can think of is that maybe the connection isn't being made properly (but that would give you different error messages.)

Then again ... mysql_query() returns FALSE with INSERT queries only if the query generated an error, so you can't really test to see that it did what you wanted it to - only whether or not the query generated an error (ie., it could be a valid query, but do nothing useful). That might be the source of your problems ...

GreyBoy

try using

mysql_select_db('ptest', $conn) or die(mysql_error());

and see if that may give you a more specific error. Also, check and make sure that the database name doesnt contain caps. I believe that could affect it.

ComputerNerd888

HI,

I with the mysql_select_db('ptest', $conn) or die(mysql_error());

I got: Access denied for user: 'ptest******@wsc1.dc1.corp.gd' to database 'ptest'

I do not even know what wsc1.dc1.corp.gd is... That is not the URL it has to log into at...

Thanks,
Andrew

P.S. I use GoDaddy... If that is of any help...

Andrew

P.S.S When I run the or die(mysql_error()); on the end of the connect line it dose not error there... So we know it is at the DataBase Select...

Andrew

GreyBoy

To me that says that there is a problem with your password. Have you made sure that your password is correct??? If thats not it, I dont really know what to tell you. Except, if I where you, I would try to contact your hosting service to see if they can tell you what is wrong. That is unless of course, some one else knows what the problem is.

ComputerNerd888

OK.. I have checked my password but I will again.. if that dose not work I will contact Go Daddy but they don't do script suport...

O well I will try them anyways...

What is a DSN for a Database? Should I have one?

Thanks,
Andrew