Mailing List Archive


Back to the month index Back to the list index
Chris Stephens (christopher.stephens@computing-services.oxford.ac.uk)
Thu, 20 Nov 1997 10:38:53 +0000 (GMT) 

Date: Thu, 20 Nov 1997 10:38:53 +0000 (GMT)
From: Chris Stephens <christopher.stephens@computing-services.oxford.ac.uk>
Subject: This is probably obvious but....
Message-ID: <Pine.OSF.3.95.971120103202.11488B-100000@ermine.ox.ac.uk>

I wonder if any of you can tell me how this is done. Consider the
following:

I have set up a DB with two tables; LINKS and COMMENTS
The table LINKS has a column called TITLE and so does the table COMMENTS
Using the msql_dbi.pl library I can retreive both LINKS.TITLE and
COMMENTS.TITLE
The problem arises when I want to refer to them later in the script using
the $row[$fieldnum{'title'}] statement.
How do I specify which TITLE I am refering to?

TIA

Chris

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Information is not knowledge..." |
                                     | Humanities Computing Unit
Chris Stephens |
                                     | Oxford University
Humanities IT Support Officer | Computing Services
                                     | 13 Banbury Rd, Oxford

Tel: +44 (0) 1865 283295 E-mail: Christopher.Stephens@oucs.ox.ac.uk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~