mysql_connect error

[jerome1g]

When I try to connect to the database I get the following error:

Unknown MySQL server host ' xo3.x10hosting.com' (4)

My dbconfig.php looks likes this:
<?php
$conn = mysql_connect('xo3.x10hosting.com', 'dbusername', 'dbpassword');
What should the sever name be ^

mysql_select_db('dbname');
?>

Thank You

 

[Derek]

Did you try 'localhost' ?

 

[techiegi]

You have to use localhost. Also mysql_connect is not deprecated.

 

[bdistler]

Also mysql_connect is not deprecated.

That extension was deprecated in PHP 5.5.0

 

[caftpx10]

Also mysql_connect is not deprecated.

I hope that was either a typo or a joke.

 

[techiegi]

That extension was deprecated in PHP 5.5.0

I hope that was either a typo or a joke.

I meant now not not sorry.

 

[jerome1g]

I changed my connect around. It now reads:

$conn = mysqli_connect('localhost',
'my_user',
'my_password',
'my_db') or die(mysqli_error());
In addition I think I had the database name as part of my user so I removed that.
I seem not to getting the connect error messages any more.

Thank You to all that have helped me.

 

[caftpx10]

Even though this seems to be resolved with the most appropriate solution, I should point out that the other issue with the script in the OP is to do with not providing a connection to mysql_select_db().
For future reference, connections stored in variables should also be put into functions such as mysqli_real_escape_string(), mysqli_close() and mysqli_query() (mysqli_num_rows and mysqli_fetch_assoc already use the results from mysqli_query so you don't need to give it any connection).