matthewpetty
Forum Replies Created
-
Forum: Plugins
In reply to: [dbview] Linking tables together to show related recordsThis is the new link to the raw data tables.
http://matthewpetty.com/theatrics/tdb-home/tdb-all-tcv-tables/Forum: Plugins
In reply to: [dbview] Linking tables together to show related recordsHi, I’ve been taking another look at this, and I’m getting somewhere with the PHP snippets and concat and so on.
I’ve seen in the FAQ that you can load a new table with a link, but it looks like that will only open one view. What I would like to do is click a link in a table in one Page, and have a new Page open, which contains two or more views, all filtered by a value passed in the link.
So my link would be:
<a href="xxx?group_id">Group Name</a>
which would open a Page containing the following views:[dbview name='Group Details' arg1=group_id] [dbview name='Shows List' arg1=group_id]Is that possible?
By the way, all my tables are here: http://matthewpetty.com/theatrics/theatre-database-mysql-all-tcv-tables/
Forum: Plugins
In reply to: [dbview] Linking tables together to show related recordsHi John, thanks for the response. I’ve made the page public now, so you should be able to see the tables and all the columns.
At the very least, I want to show a list of Performances, including links to the Group, and then when I click on the Group, it shows info about that Group, along with a list of Performances with that Group.
Once I can get that working, it should become clearer.
Thanks for your help,
MatthewThanks for the suggestion!
Having thought about it some more, I’m going to try something else with SQL.