[PHPLIB] Re: Multiple database problems From: Eric Thelin (eric <email protected>)
Date: 11/11/99

On Thu, 11 Nov 1999, Alec Effrat wrote:

> Eric,
> Here is an alternate solution. Use the database name in your SQL
> statements. I haven't tried this but:
> "SELECT * FROM [databasename.]tablename;"
> "INSERT INTO [databasename.]tablename;"
>
> Here are some example queries:
> SELECT uid, userid FROM baselib.auth_user WHERE userid LIKE "a%";
> REPLACE INTO baselib.auth_user (uid,userid)
> VALUES('something','anything');
> SELECT id, description FROM data.inventory WHERE id BETWEEN 10 AND 20;
>
> Where as baselib and data are my two databases.

This is exactly what I was suggesting. The reason that I am sending it
to this list is that this must be addressed in phplib. I would rather
see it added to phplib itself than just make these changes to every new
version that comes out. That way the same issue is solved for everyone.
If this will work with all databases I will put together a patch and
submit it.

Eric

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.