This topic is locked

Details on Masterpage

1/10/2007 9:08:58 AM
PHPRunner General questions
I
itxlieni author

Hi
It is possible to show detail informations on the masterpage under each masterrecord?

Example, you have some company records in a table and multiple contact informations in another table.
THX

Version 3.1 everything works fine <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4346&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />

J
Jane 1/10/2007

Hi,
you can do it using JOIN clause.

Edit SQL query on the Edit SQL query tab and then modify appearance of your LIST page on the Visual Editor tab.

Here is a sample query:

select `mastertable`.`field1`,

`mastertable`.`field2`,

`detailtable`.`field3`,

`detailtable`.`field4`

from `mastertable` inner join `detailtable`

on (`mastertable`.`field1`=`detailtable`.`field3`)