Connect to SQL

[#1]

Hi,
I'm sure I'm being dim, but can't work this one out!
I'm trying to use php in my ccgi space to connect to my SQL database, but I can't seem to make it work.
I'm currently using the following - I'm assuming it's the $server definition that's not correct but I don't know what to change it to!
$server = "rumpus";
$user = "greenofashbourne";
$pass = "password";
$database = "greenofashbourne_pn";
$connection = mssql_connect($server, $user, $pass)

Any help appreciated.
Thanks,
Stuart

[#2]

The password is not the same as your account password, it is created when you activated MySQL and included in the email that is sent to you after activation.
If you can't remember it just disable MySQL and enable it again and wait for the email with the connection details.

[#3]

Amazingly, I have got the email with the database password on it - so I know that is correct (and I can log into the SQL through PHPMyAdmin - I just can't use it with a .php file called from ccgi.greenofashbourne.plus.com).
Thanks,
Stuart

[#4]

try rumpus.plus.net

[#5]

Thanks! That worked (after also spotting that I needed to change mssql to mysql!)
Cheers,
Stuart

[#6]

"rumpus" alone would probably work after correcting the name of the "connect" function.