Forgive me, this is a crosspost from r/mediawiki.
I’m trying to build a database for the theatre community in my area, sort of an IBDB, but just for Northeast Florida. (Or IMDB, if you’re not a theatre nerd.)
I want to be able to put in a list of the cast and crew members of each show’s page, and then query that list on the actor’s page.
In other words:
|Bob Johnson||Mr. Large|
And this page would be a query:
|Show 2||Mr. Large|
I’ve tried to do this with Cargo, but I had to create a template that generated a table for each member of the cast. It looks like this…
In my opinion, it looks dumb having that many tables on the page instead of just one table that submits all of the rows. I know how I would do this with PHP and MySQL, but apparently Cargo can only store one line in the table at a time.
I haven’t tried Semantic yet, but I wanted to ask before I dived into it.
Is it possible to submit multiple rows to Cargo at one time, or if not, is it possible to format the cargo_store template into a table with multiple rows?
If Cargo cannot do the job, is Semantic capable of it?
If you want to see what I’m working on specifically, I have it started at jaxplays.com. Right now all of the pages are manually entered. There’s no queries pulling any information.
A good show page example is A Funny Thing Happened on the Way to the Forum ,
and a good person’s page is Michael Lipp.