2. PHPRunner General questions
  3. Hyperlink from second table
This topic is locked

Hyperlink from second table

 		2/9/2006 12:30:35 AM
PHPRunner General questions
D
 doingbiz author

I have a project with a page displaying a link to a static page. The links are in a second table with 3 fields:

ID

Name

Link
In the second table the Link field shows as a clickable hyperlink.
My problem is in the first table. I have a field LinkID which is a lookup from the second table with view set as hyperlink. The field shows the link correctly, but it is not a clickable hyperlink as it is in the second table.
I feel like I'm missing something simple, but I have been unable to find it. Can someone point me in the right direction?
admin 2/9/2006

Use JOIN SQL query to pull data from two tables at once:

select ...

Link

from Table1 inner join Table2 on

Table1.LinkID = Table2.LinkID


Set View as type of Link field to Hyperlink.
D
 		doingbiz author 2/10/2006

Use JOIN SQL query to pull data from two tables at once:


select ...

Link

from Table1 inner join Table2 on

Table1.LinkID = Table2.LinkID


Set View as type of Link field to Hyperlink.


Where should this be added in PHPRunner? When I add it on the Edit SQL query page everything gets messed up.
admin 2/14/2006

Hi,
yes, you should modify a query on Edit SQL query tab in PHPRunner.
You can post your both tables full structure here and I'll help you to construct an SQL query.