Posted by Paul Lautman on 07/14/07 09:20

Michael wrote:
> I think you mean different tables, not different databases. It's
> distinctly more difficult to select information from separate
> databases in the same query (if not impossible). In any case, I think
> the best case to deal with your problem is the PHP function
> mysql_fetch_field http://www.php.net/mysql_fetch_field. It returns an
> object, so you can call:
> $table = mysql_fetch_field($result, $colNum)->table; to get the table
> name of the colum in position $colNum.
>
> Hope that helps!

Oh it is just SO difficult to get information from separate databases in the
same query:

SELECT * FROM database1.books2006, database2.books2007;

Wasn't that just so difficult - nearly impossible!
http://dev.mysql.com/doc/refman/5.0/en/identifier-qualifiers.html

[Back to original message]