Posted by Gordon Burditt on 06/06/05 07:05

>I'm (trying) to help a friend setup a MySQL db and use some simple
>scripts on a site hosted with GoDaddy. I note that GoDaddy appears to
>use Microsoft. I have done this:
>
>$connection = mysql_connect("localhost","mydatabase","password")

The second parameter to mysql_connect is a user name, not a database
name. Depending on how hosting companies assign these things, this
may not make any difference. Also, sometimes the host name that
works is the host name of the machine, NOT localhost (even if they
are the same machine), due to permissions setup. And sometimes the
database has its own machine.

> or die ("Couldn't connect to server.");
>$sql = mysql_query("SELECT * FROM dummy");
>$row = mysql_fetch_array($sql);
>echo $row['name'];
>?>
>
>on several Apache servers and it always seems to work. I created the
>MySQL database using the GoDaddy control panel (which is very confusing
>and poor IMO). I dove into phpAdmin and was able to do stuff. But I
>can't get php to connect.
>
>Is there something different I need to do for Microsoft servers?

I think you need to ask GoDaddy.

Gordon L. Burditt

[Back to original message]