Re: Is select_db necessary?

Jay Blanchard wrote:

[snip] Is the database selection necessary, or is that implied with a SELECT or other SQL command? [/snip] It depends on the database (as you have seen in many of the responses), but there is a way to keep from doing this if the database is ANSI compliant using proper SQL syntax; SELECT a.foo, a.bar FROM myDatabase.myTable a WHERE you set other conditions here All that is required is that you establish a connection to a server.

If I recall correctly, this will cause issues with replication in MySQL... insofar as you perform amodifying query. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP