Cannot connect to localhost using GoDaddy

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")
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?

Thanks,

re: Cannot connect to localhost using GoDaddy

Dale wrote:[color=blue]
> 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")
> 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?
>
> Thanks,
>[/color]

Did you ask GoDaddy? The database may not be on your host. Check their
documentation.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Cannot connect to localhost using GoDaddy

>I'm (trying) to help a friend setup a MySQL db and use some simple[color=blue]
>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")[/color]

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.
[color=blue]
> 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?[/color]

I think you need to ask GoDaddy.

Gordon L. Burditt