You can access the column by index position instead, or use as column alias:
"select a.col col1, b.col col2 from a,b where a.key = b.key"
Then access using col1 and col2.
"Mark Newnham" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Not sure if this is really the right list to ask on, so please excuse me.
> I am trying to use the adodb db class with php4/mysql. On problem i have
> is that if i retrieve 2 tables with a join and the 2 tables both have a
> field of the same name, the command
> $result->fields("fieldname") always returns the value of the second field
> that name.
> i could loop through the fields via index, then use fetchfield() to
> the name, but generically, I would also like to retrieve the table that
> field is attached to. Does anyone know of a way to do this or a command
> has this option?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]