Re: DISPLAYING LISTS based on fields

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?

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?

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

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.

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

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

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

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.