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 csdesign - January 30, 2015

Hello Claire, 

Sorry for taking so long to follow up on this! 

Yes, there is a table called bird_photos and ALL birds were already entered into it when the client decided they wanted them easily divided into subcategories (Songbirds, Waterbirds, Birds of Prey, All Other Birds) 

I've included a screenshot of  of section editor & editor pages.  I'm also attaching my revised php page. I have managed to make something that resembles progress. Here's the page link: 

http://www.billdraker.com/bird-photography-subcats.php

in the Load records section - whichever record I put this line after - makes the first image of that subcategory appear as the first image and the last image. The first image is not supposed to be displaying a subcategory image, but rather the first image of the main gallery (ALL birds) 

    $bird_photosRecord = @$bird_photosRecords[0]; // get first record

If each thumbnail pulled the first image from the appropriate subcategory (Songbirds, Waterbirds, Birds of Prey & All Other Birds) - then that's all I'm trying to achieve.  

Does this help? I sure hope so!!  Thank you for your help! Tina

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 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.