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?

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! 

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

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.