RE: [PHP-DB] MySQL CONNECTION PROblem
| From: | John W. Holmes | Date: | Mon, 09 Jun 2003 11:50:35 +0000 |
| Subject: | RE: [PHP-DB] MySQL CONNECTION PROblem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28447@lists.php.net to get a copy of this message | ||
> i have the dbconnect.php as :
> //////////////////
> <?php
> mysql_connect("192.168.0.111" , "root" , "pass") or
> die ("Couldn't connect to database");
> mysql_select_db("DatabaseName") or
> die("sorry database not found");
> ?>
> ///////////////////
> when i put localhost instead of the IP address of my machine (localy)
i
> got
> the following error...
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result
> resource in c:\inetpub\wwwroot\kt\superv_list.php on line 5
> No Data Found..
>
> what is my problem, this was a test to connect to my database on the
same
> machine . but i replaced the "localhost" with my machine IP address..
do i
> have to put a domain name instead of an IP if i want to connect to a
> remote
> server on the internert?
Your query failed. Use mysql_error() to find out why.
---John W. Holmes...
Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/