Re: newbie dumbass question

Have a look on the statements below, both are PHP-MySQL and has the "link_identifier" as an optional parameter, if you omit it the server thinks you are using the last connected database. 1st. - mysql_query(string query, int [link_identifier] ); 2nd. - mysql_db_query(string database, string query, int [link_identifier] ); I'm sure you can submit queries to more than one database one by one. I'm not sure the structure "FROM DB1.Table1 DB2.Table2" works out. You have to be conected to both databases of course. I think you should submit separeted queries to each database, and get the result in PHP variables to process them latter. From PHP-Html_Manual : "mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier. If link_identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link as if mysql_connect() was called with no arguments, and use it. " I hope this helps. Jayme Jeffman Filho. www.conex.com.br/jjeffman -----Mensagem original----- De: Adv. Systems Design <asd_2000@yahoo.com> Para: PHP List <php-db@lists.php.net> Data: Terça-feira, 29 de Agosto de 2000 10:11 Assunto: [PHP-DB] newbie dumbass question >I tried looking through the mysql docs, but did not >find an answer...can mysql lookup (select) values from >multiple databases? (as opposed to multiple >tables)...I am assuming it can, but need to confirm >(what would a select statement look like?). > >Thanks > >Luis > >__________________________________________________ >Do You Yahoo!? >Yahoo! Mail - Free email you can access from anywhere! >http://mail.yahoo.com/ > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net >