Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Chris
Stan wrote: So ... if I enter "mysql -h mysqlServer -u stan -p" and then enter the password, I get connected without a problem ... I get the mysql client prompt. You haven't selected a db. Inside mysql: use database_name; And the mysql_connect() statement in my code does not "die". But th

Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Micah Stevens
Okay, on the command line, then connect, and then select your database, what's the error message it gives? -Micah On 10/21/2008 11:06 AM, Stan wrote: So ... if I enter "mysql -h mysqlServer -u stan -p" and then enter the password, I get connected without a problem ... I get the mysql client p

Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Stan
So ... if I enter "mysql -h mysqlServer -u stan -p" and then enter the password, I get connected without a problem ... I get the mysql client prompt. And the mysql_connect() statement in my code does not "die". But the mysql_select_db() statement in my code does "die". "Micah Stevens" <[EMAIL P

Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Micah Stevens
Try it on the command line from the webserver: mysql -h hostname -u Stan -p Password See if that connect works. -Micah On 10/21/2008 04:26 AM, Stan wrote: Nope ... that wasn't it. The mysql_connect() works. It's the mysql_select_db() that's failing. -- PHP Database Mailing List (htt

Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Stan
Nope ... that wasn't it. The mysql_connect() works. It's the mysql_select_db() that's failing. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_select_db

2008-10-21 Thread Stan
My include, navigationDB.inc, contains: CODE: END CODE: (no change) and I added an instance of that user with that password at the new IP address on the MySQL server before testing. Hmmm ... but what I didn't do was restart MySQL. -- PHP Database Mailing List (http://www.php.net/) To unsub

Re: [PHP-DB] mysql_select_db

2008-10-20 Thread Stut
On 20 Oct 2008, at 13:03, Stan wrote: UBUNTU Server v8.04 On a web page: CODE: require_once 'frames_includes/navigationDB.inc'; $navigation_connection = mysql_connect($navigation_hostName, $navigation_userName, $navigati

[PHP-DB] mysql_select_db

2008-10-20 Thread Stan
UBUNTU Server v8.04 On a web page: CODE: require_once 'frames_includes/navigationDB.inc'; $navigation_connection = mysql_connect($navigation_hostName, $navigation_userName, $navigation_passWord) or die("Failed to conne

RE: [PHP-DB] mysql_select_db() and mysql_query()

2002-11-30 Thread John W. Holmes
> A friendly error message advised me that "mysql_db_query" is deprecated > and > to use "mysql_select_db() and > > mysql_query()". but I can't seem to get past this return in the Browser: > "Parse error: parse error in c:\program files\apache > > group\apache\htdocs\crup_hs_local\result.php on l

Re: [PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Beth Gore
Hi Dan, Dan Martin wrote: group\apache\htdocs\crup_hs_local\result.php on line 58". I think I don't understand the basic syntax. /*$result = mysql_db_query($dbname,$sql);*/ /*mysql_db_query is deprecated; use mysql_select_db() and mysql_query()*/ $result = mysql_select_db($dbname) or die(mysql_

[PHP-DB] mysql_select_db() and mysql_query()

2002-11-29 Thread Dan Martin
A friendly error message advised me that "mysql_db_query" is deprecated and to use "mysql_select_db() and mysql_query()". but I can't seem to get past this return in the Browser: "Parse error: parse error in c:\program files\apache group\apache\htdocs\crup_hs_local\result.php on line 58". I think

[PHP-DB] "mysql_select_db() or die()" fails when db exists

2002-01-17 Thread Malcolm White
Hi, I am experiencing a problem with this function; funcion do_connect($server, $db, $user, $pass){ $link = @mysql_pconnect($server, $user, "$pass") or die("error: mysql_pconnect()"); mysql_select_db($db) or die("error: mysql_select_db()"); } when supplied with variables that are c

[PHP-DB] mysql_select_db api bug?

2002-01-04 Thread Jean-Pierre Arneodo
The function mysql_select_db set the db for one or for all link identifiers? The table my_table is in db1 but the active database seems to be test on link #8. Here the result with PHP 4.1.0 and MySQL 3.23.41-log: mysql_pconnect() id1=Resource id #8 mysql_select_db(db1,Resource id #8) mysql_pconn