This will give you more information, Keith:
<?php
function zippy( $msg, $file, $line, $errno, $error )
{
echo "DB error $msg in $file on line $line <br>Error: $errno <br>Error
Message: $error <br>" ;
die();
}
$db_host = "localhost";
$db_username = "zzz";
$db_password = "secret";
$db_name = "danens";
/////////////////////////////////////////////////////////////////////////////////
// connect to the database server and select a database
$db_conn = mysql_connect($db_host, $db_username, $db_password) or zippy(
"CONNECT", __FILE__, __LINE__, mysql_errno(), mysql_error() );
$db = mysql_select_db($db_name, $db_conn);
echo "OK";
?>
On 6/19/06, Keith <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I am setting up a site for a client that requires signup and
> login. I have written most fo the code but, for some reason am
> have trouble with the database connection. The problem is with
> the connection. I believe I have the right server but, have had
> trouble getting the correct iser and password. Is there a way to
> determine what is going wrong in the connection because
> setting up die with a message doesn't tell me anything other
> than the connection failed. I going back to client and getting the
> support # from yahoo who set up the server and
> database.
>
> Hopefully I can talk to the person who set up the server for him
> and get the proper server, user and password. It would be nice
> to know how to troubleshoot the connection in a more
> meaningful way.
>
--
Gerry Danen
Developer support:
http://dev.danen.org/
http://groups.yahoo.com/group/php_and_mysql/
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/CefplB/TM
--------------------------------------------------------------------~->
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
