[Typo3-dev] SQL wrapper functions

[John Begley]

>hi,
>
>> I'm still confused.  I even created another instance of t3lib_db to use
>to
>> connect my other database, and there are still the same warnings
>(Warning:
>> mysql_fetch_assoc(): supplied argument is not a valid MySQL result
>resource
>> in D:\TYPO3\dummy-3.7.0\t3lib\class.t3lib_db.php on line 723)  And I see
>the
>> same warnings like Table '<my_dbase>.cache_hash' doesn't exist - there
>still
>> seems to be a cross over problem between 2 databases...??
>
>do you use different username and password to connect to the 2nd
>database on the same host? if not it is not possible!
>
>if the user you connect to the T3 database, has all needed rights for
>the 2nd database you can use the same link and change your sql to
>something like.
>
>select * from <your_db>.your_table;


Thanks for everybody's input.  I see the problem clearly now.

Is it not possible for Typo3 code to select its database each time is does
something?  Should a programmer assume anything at all about the way
databases are set up?  If not then I don't see any easy way except to create
a new connection each time the page is accessed (mysql_connect)

Cheers
John