[RESOLVED] What's wrong with this code?

[FatStratCat]

When I upload the code below I get this error:

Could not select the database because: ' . mysql_error() . ''); } } else { die ('

Could not connect to MYSQL because: ' .mysql_error() . '

Here is the code. I doubled checked the values for the dbIP, username, and pwd:

<?php  

//This script will access the current database. 
// address error handling.
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

Connect to Database
   if ($dbc = @mysql_connect ('databasehost ip', 'username', 'password')) {

   if (!@mysql_select_db){
	     die ('<p>Could not select the database because: <b>' . mysql_error() . '</b></p>');
	 }

 } else {
    die ('<p>Could not connect to MYSQL because: <b>' .mysql_error() . '</b></p>');
 }

 ?>

[devinemke]

you are not feeding [man]mysql_select_db[/man] the name of your database

[Houdini]

Ha

[FatStratCat]

do I need another line that says that? I thought the !@mysql was an escape if the information in the connect line above was not correct.

[drew010]

the @ symbol in front of a function call, just tells php not to output any error messages the function generates. the ! is the not operator which gives a shorthand in that case so you can say !mysql_connect rather than mysql_connect(...) != true
mysql_select_db is a function, and takes an argument, which is the database to select. see [man]mysql_select_db[/man]

[FatStratCat]

I knew what the ! did, but I wasn't sure what the @ symbol did.

Ok. I copied the db connect code from the link you guys gave me, changed the particulars to mine, and It worked. Thanks. The other code I used was from a book.

Hoo boy do I have a long way to go.