Pulling in first record from each category (set by list/radio buttons)

4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 24, 2013   (RSS)

Hi there,

I'm working on a new site and wondered if the following was possible and if so, how?

I have a site for a theatre co. where we will be listing all shows under one record and I'll then be using a list and radio buttons to display the records on designated pages. I've done this before to get a site to display all upcoming shows on one page and all archived shows on another which I'll be doing here but what I also wanted to do with this one is to get the list page to display the first record for each type of show 'spring', 'spellbound', etc

So there are 6 radio buttons:
PANTOMIME - SHOWSTOPPERS - AUTUMN SHOW - SPELLBOUND - SPRING SHOW - ARCHIVE

And on the main list page I would like the first record for each type, except the archived shows, to be displayed. Here is the HTML page so you can see what I mean!
http://www.fromemtc.co.uk/NEW/forthcoming-shows-in-frome.html

Is this possible? Thanks!

Hi Jason,

Thanks for this. What would I then need for each top record per section to be displayed as per that html page I linked to ie. the top record for x show type - the top record for y show type - the top record for z show type etc .

One row of the 5 top records: http://www.fromemtc.co.uk/NEW/forthcoming-shows-in-frome.html

Do you think this would be easier if we got you guys to look into it and could you tell me how much that would cost?

Hannah

By Jason - September 24, 2013

Hi Hannah,

This code can be embedded in your HTML where you want the show records to be displayed.  Each iteration of the loop should output the HTML for a single one of your show "boxes".  If you would like us to step in and implement this for you, we can certainly do that.  If you could please email consulting@interactivetools.com we can go over some options.   As this looks like a pretty simple integration, I would expect the cost to be quite low.

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/