|
|
Posted by Michael on 07/13/07 19:04
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!
Navigation:
[Reply to this message]
|