can not connect to database

[ThaiAn]

i have a php file

 <?php$mysql_host='localhost';$mysql_user='root';$mysql_pass='root';$mysql_db='b_database';  if(!@mysql_connect($mysql_host,$mysql_user,$mysql_pass) and !@mysql_select_db($mysql_db)) { echo 'error';}else{    if($query=mysql_query("SELECT `food`,`color`  FROM `food` ORDER BY `id`"))    {echo 'ok';    }    else    {    echo mysql_error();    }} ?>
 

 

 when i run the code it always says that no database selected. even i had created a it's database.Sorry for my bad english

Edited May 5, 2013 by ThaiAn

[trq]

Remove the error suppressors so that you might actually see the proper error.

[ThaiAn]

 i removed '@' at : if(!mysql_connect($mysql_host,$mysql_user,$mysql_pass) and !mysql_select_db($mysql_db))

it still output 'No database selected'

[androidd]

mysqli_connect maybe?

 

or something like:

 

$db_connect = mysqli_connect($host, $user, $pass, $db);

if (!$db_connect){

echo "Failed" . mysqli_error();

}

 

Kinda new at this myself but this worked for me.

[DavidAM]

Have a look at the mysql_error() when the connection OR the select db fails. If you care going to do it that way (in a single IF statement) it needs to be OR not AND.

 

if(!mysql_connect($mysql_host,$mysql_user,$mysql_pass) OR !mysql_select_db($mysql_db)){
  echo 'error: ' . mysql_error();
}

with AND, since you are looking for failure, you only get that error condition if BOTH fail. It would appear that the connect succeeds but the select fails.

[ThaiAn]

thanks i got it