but when i used mysql_error() i got : "sorry database not found"
as my dbconnect.php file includes <? mysql_connect("192.168.0.111" , "root" , "password") or die("SORRY CANNOT CONNECT") ; mysql_select_db("kt") or die("sorry database not found"); ?> and the user table of mysql database : # # Dumping data for table `user` # INSERT INTO user VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); INSERT INTO user VALUES ('%', 'root', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N', 'N'); INSERT INTO user VALUES ('localhost', '', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); INSERT INTO user VALUES ('%', '', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); so it has the '%' value so it can be accessed by any host.!!!1 any comment ??? "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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/ > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php