Mysql

[Xena]

Is there a away to access a mysql database via php? My hosting company says to use this script

$hostname = "localhost";
$usernamedb = "username";
$passworddb = "your_password_here";
$dbName = "username";

MYSQL_CONNECT($hostname, $usernamedb, $passworddb);
@mysql_select_db("$dbName");


It didn't work! What did I do wrong?

[niv]

Try removing the @ and replacing MYSQL_CONNECT with mysql_connect. I don't know if it is case sensitive or not.

[Xena]

Didn't work :-(

[harrylmh]

Maybe you got your database name wrong or something.
What I'd do is to see what the error is:

if (!mysql_connect($hostname, $usernamedb, $passworddb))
echo mysql_error();
if (!mysql_select_db("ur_dbname"))
echo mysql_error();

maybe the error message would be more informative like this.

[ashben]

Shouldn't this ...

@mysql_select_db("$dbName");

.. be ..

mysql_select_db($dbName);

[harrylmh]

oh yeah...