How can I get the nth upload for a record?

Hi Ron,

here's a recipe from my CMSB Cookbook http://www.thecmsbcookbook.com that adresses that question.

Hope it helps,

Jerry Kornbluth

DISPLAY A SPECIFIC IMAGE FROM A SPECIFIC RECORD


My client wanted to be able to display a specific image from a group of records and multi image uploads.

I couldn’t get this to work until Chris Waddell from Interactive Tools unlocked the secret.

He said:

If $affiliationsRecords is a list of all your records, then $affiliationsRecords[0] will give you the first record, $affiliationsRecords[1] will give you the second, etc. It's a little confusing that the counting starts at 0 instead of 1.

$affiliationsRecords[3]['logo'][2] will grab the fourth record ([3]), its list of images (['logo']), and select its third image ([2]).

Since $affiliationsRecords[1]['logo'] refers to the list of images. You need to use $affiliationsRecords[1]['logo'][0] if you want to refer to a specific image ([0] gives you the first one, etc.)

You’ll need to define a variable for the specific image. To call the 3rd image from the 4th record I used

_____ code ________________________________________________

<?php $myImage = $affiliationsRecords[3]['logo'][2]; ?>

__________________________________________________________

The code that you’d use in the body of your viewer page where you want the image to display would be:

_____ code ________________________________________________

<?php $myImage = $affiliationsRecords[3]['logo'][2]; ?>
<img src="<?php echo $myImage['thumbUrlPath'] ?>" width="<?php echo $myImage['thumbWidth'] ?>" height="<?php echo $myImage['thumbHeight'] ?>" alt="" />

__________________________________________________________

You can also define other variables, like this one for the link to a detail page relating to the same record:

_____ code ________________________________________________

<?php @$mylink = $affiliationsRecords[4]['_link']; ?>

__________________________________________________________

Then the code including a linked image might look like this:

_____ code ________________________________________________

<?php @$myImage = $affiliationsRecords[3]['logo'][2]; ?>
<?php @$mylink = $affiliationsRecords[3]['_link']; ?>
<a href="<?php echo $mylink ?>"><img src="<?php echo $myImage['thumbUrlPath'] ?>" width="<?php echo $myImage['thumbWidth'] ?>" height="<?php echo $myImage['thumbHeight'] ?>" alt="" border="0"/></a>

__________________________________________________________