Re: DISPLAYING LISTS based on fields

10 posts by 2 authors in: Forums > CMS Builder
Last Post: February 12, 2015   (RSS)

By csdesign - December 22, 2014

In response to: [url "http://www.interactivetools.com/forum/forum-posts.php?postNum=2233250#post2233250"]DISPLAYING LISTS based on fields[/url], ...

Hello! 

Using the same methods that I have used on another site (archived link above), I've been trying to get multiple subcategory photos to display on a single page. The subcategories are determined by a list of check boxes.  Any single image could be in 1+ subcategories. 

Here's the page I'm working on.
http://www.billdraker.com/bird-photography-subcats.php

Getting this error: 
Notice: Undefined variable: record in /home/billd3/public_html/bird-photography-subcats.php on line 115 

This worked on the other site so I'm not sure what I'm doing wrong now. 

The page is attached. Thanks so much for your help!!  Tina

By claire - December 23, 2014

Hey there

This looks like you're only loading a single record here, not multiple subcategory photos. What does the structure of the bird_photos section look like, and what should the page look like?

--------------------

Claire Ryan
interactivetools.com

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

By csdesign - December 23, 2014

On that subcategory page - I do want it to be a single record - the first image that has been checked for that subcategory. For instance, whatever the last "bird of prey" image is - I would like that to show up as a single image with a static link that I will set - which will go to the main Birds of Prey Gallery.  Same for Songbirds, Waterbirds, View All Birds, etc.  And then I'm doing the same thing with Mammals (small mammals & large mammals) 

Each subcategory will have 1 image showing on this subcategory page ( http://www.billdraker.com/bird-photography-subcats.php ) and then link to the corresponding subcat galleries below:

http://www.billdraker.com/bird-songbird-photography.php
http://www.billdraker.com/bird-waterbird-photography.php
http://www.billdraker.com/bird-birdsofprey-photography.php
http://www.billdraker.com/bird-allotherbirds-photography.php

http://www.billdraker.com/mammal-small-photography.php
http://www.billdraker.com/mammal-large-photography.php

Does that help explain it? 

Thanks, Claire! 

By claire - December 24, 2014

Yeah, this explains it better, although I think you've got a case of over-engineering going on here. All the individual category pages are the same, so you don't need to have separate viewer files for each one.

So there's a table called bird_photos - is the category stored in that? And what does the category field look like, if so?

--------------------

Claire Ryan
interactivetools.com

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

By claire - February 2, 2015

Hi Tina

I think the actual structure - multiple getRecords calls to get the first in each subcategory - is the simplest solution. You're just missing a few key variable names.

I've amended the file - see attached. It's untested, but I really just cleaned up some of the code.

--------------------

Claire Ryan
interactivetools.com

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

By claire - February 2, 2015

Sorry, the file wasn't attached. Here it is now.

--------------------

Claire Ryan
interactivetools.com

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

By csdesign - February 11, 2015

Claire, has anyone told you how awesome  you are today??!!!  Thanks so much!  :) 

By claire - February 12, 2015

No problem :) let us know if you need any more help.

--------------------

Claire Ryan
interactivetools.com

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

By csdesign - February 12, 2015

Thank you! This one works great and I changed the "view all photos" thumbnail to pull a random image so none of the thumbs on the subcat page would be duplicated.