This topic is locked

Viewing records from 2 tables

8/30/2005 5:07:51 PM
PHPRunner General questions
B
bwilliams author

I have two tables. The master table is Contacts and a details table is Companies. Is there a way to list/view all fields from both tables on the same page? The way I have it set up only one table can be viewed at a time. (I have a caption for each table on the results page).

Sergey Kornilov admin 9/1/2005

Hi,
If you'd like to display Master record info on the Details page check off corresponding checkbox on the Datasource table tab in PHPRunner.
Also you can create SQL query on theEdit SQL querytab in PHPRunner to join all fields from both tables.
If you have problems with SQL query send to support@xlinesoft.com your database structure. I'll help you.