On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
> Let's say I performed the following query using Perl DBI:
>
> $row = $dbh->selectrow_hashref(<<"~");
> SELECT fanfics.handle, authors.handle
> FROM fanfics, authors
> WHERE fanfics.aid = authors.aid
> ~
>
> I won't be able to access both fanfics.handle and authors.handle
> this way, because they're called "handle". I would like to be able
> to access them e.g. by doing $row->{fanfics.handle} and
> $row->{authors.handle}, or something like that.
>
> What workarounds have people found for this problem?
Use a column alias:
SELECT fanfics.handle as f_handle, authors.handle as a_handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
Then refer to them as $row->{a_handle} or $row->{f_handle}.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
