2. PHPRunner General questions
  3. Listing And Hyperlink
This topic is locked

Listing And Hyperlink

 		3/31/2009 5:59:44 PM
PHPRunner General questions
L
 lococable author

Hi I am evaluating the software to see wether I am able to use it affectively.
I have a database and table that holds peoples names and there details.
The table is setup like this,
Table Name - People
Table fields - persons_second_name, persons_first_name, persons_persons_location
I want to create a page that lists all of the unique records from "persons_second_name" and make it so it is a hyperlink and when you click it on it shows you all the records that this contains.
This is for a family tree so there may be many people that have the last name "Frankheir" rather than listing each one I would like to be able to a see a list of last names, click on the one that relates and view all the people that have that last name.
I have been fiddling around with PHP Runner and I can get to list all of the record in one page but not split it up like this.
Can anyone suggest what the way to do this in PHP Runner would be?
Sergey Kornilov admin 3/31/2009

It looks like a Master-Details relationship to me where the same table is both master and details.
I would suggest to add a View for People table on Datasource tables screen and setup Master-Details relationship between 'People' and 'View of People'. This way you can achieve what you looking for.
L
 		lococable author 4/1/2009

Thanks for the suggestions, so I have one view in the Datasources tables section or two?
If it is one how to do I setup a relation ship with only one view?
Sergey Kornilov admin 4/1/2009

On Datasource tables screen create a view for Peopes table. Check off the check box next to both table and view which gives you two tables on the diagram. Now you can link them to create Master-Details relationship and proceed from there.