Posted by GD on 07/14/07 13:33

On Fri, 13 Jul 2007 19:04:33 -0000, Michael <dimo414@gmail.com> 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!

thank you very much for your response.
You are right i meant different tables, not databases!! sorry about
that.

GD

• Next in forum: can't get to mysql server 4.1 directory on win98se
• Prev in forum: MySQL GROUP BY ignoring ORDER BY
• Thread view: Re: Newbie question about multiple databases

[Reply to this message]