mysql_connect() help?

[TheStalker]

Hi all,

i am starting to move my website from my local host where i have been doing my devlopment work to my live web hosting company.

obviously this will need to change my mysql_connect() to connect with the online database at my hosting company.

Atm my file just looks like this:

<?php
	$dbcnx = mysql_connect("localhost", "root", "");
	mysql_select_db("mydb",$dbcnx);
?>

Now im having trouble working out what i need to replace the values with. I know what they all mean server, username, password.

How do i know what the servername is? ( i have ahosting account with godaddy if that helps)

Also is the username and password the username and password for just the database or the hosting account login?

Sorry if these sound dumb questions but ive tryied a few things and all of them result in no connection to the db so far.

thanks :o

[NogDog]

"localhost" will probably still be OK unless your hosting plan/service uses a separate database server. In that case you will need to check with them (or their info/FAQ pages) to find out. The username and password will likewise be site dependent. You may need to go into the site control panel and define the desired username, password, and likely also create the database itself.

[TheStalker]

ok, ill give it another shoot and get back to you. Thanks for the reply 🙂