Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
gt; socket anyways. >> >> Something else to check; if you're using two logins, one for remote, one for >> local, verify that their database permissions are the same. -- Thomas Deliduka IT Manager - Xenocast Street Smart Media Solutions http://www.xe

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
ish a link as if mysql_connect() was called > without arguments, and use it. > > Every subsequent call to mysql_query() will be made on the active > database. > > Peter > > On Fri, 15 Aug 2003, Thomas Deliduka wrote: > >> The ONLY way I have been able to work a

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
> select * from table1 > > use: > > select * from database1.table1 > > if that works, and the php command doesn't that may mean the the mysql client > lib is broken, although, I've been using it with mysql 4 and it seems to work > fine. > > -Micah >

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-17 Thread Thomas Deliduka
> default; you can override this action by specifying which DB handle to use > for a given query. Replace $dbh with $dbh2 to select from tables on the > second database. > > Peter > > On Fri, 15 Aug 2003, Thomas Deliduka wrote: > >>

[PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-15 Thread Thomas Deliduka
ata from "db2"? This only happens when I'm connecting from Server 2 to server 1 it does not happen any other time. Incidentally it doesn't happen when I'm connecting from server 2 to another server running mySQL 3.23.54 there is no problem at all. I'm thinking it's a p