How to get the second article image only?

caruso_g · 2011-03-08 16:32:57

Hi guys, I need to get only the second article image, but with this code:

<txp:images offset="1" wraptag="div" class="header_image" auto_detect="article" />

I got this HTML:

<div class="header_image">
    <a href="http://mywebsite.com/index.php?c=site-design&amp;context=image&amp;s=product_name&amp;p=14">
        <img src="http://mywebsite.com/images/14t.png" alt="Product icon">
    </a>
</div>

Which, instead, is the first image. Btw, I also just want the full image, I don’t want the thumbnail and I don’t want the link to the full size image.

I also tried :

<txp:images offset="1" wraptag="div" class="header_image" auto_detect="article">
    <txp:image />
</txp:images>

but it still shows me just the first article image… argh.
Where’s the trick? I really don’t see it. Thank you all for your help!

Bloke · 2011-03-08 16:48:33

Very close. How about this for a trick:

<txp:images offset="1" limit="1" wraptag="div"
     class="header_image"
     sort='FIELD(ID,<txp:custom_field name="article_image" />)'>
   <txp:image />
</txp:images>

To trigger the offset you need a limit (any limit will do) and to make sure that the tag keeps the order of the IDs as you specified in the article image field you need the sort hack to retrieve the raw list of images and then supply that to MySQL.

Last edited by Bloke (2011-03-08 16:48:58)

caruso_g · 2011-03-08 16:55:21

OK, it seems I got it working. My fault, of course.
Offset is desc so last image added (in fact the second one I needed) was skipped, and first one was displayed.
Right code is:

<txp:images wraptag="div" class="header_image" auto_detect="article" limit="1">
    <txp:image />
</txp:images>

Sorry if I made you waste your time. I’ll left it here as reference if someone else should get the same problem.

More, for reference as well, what if I had more then two images? How could I get the second one only if I have three images?
Simple enough:

<txp:images wraptag="div" class="header_image" auto_detect="article" offset="1" limit="1">
    <txp:image />
</txp:images>

Thank you all anyway! :)

caruso_g · 2011-03-08 17:03:27

Bloke wrote:

Very close. How about this for a trick:

<txp:images offset="1" limit="1" wraptag="div"
     class="header_image"
     sort='FIELD(ID,<txp:custom_field name="article_image" />)'>
   <txp:image />
</txp:images>

To trigger the offset you need a limit (any limit will do) and to make sure that the tag keeps the order of the IDs as you specified in the article image field you need the sort hack to retrieve the raw list of images and then supply that to MySQL.

Hi Stef! Thanks a lot, really interesting trick. The issue is that I want to limit as much as possible the use of custom fields (and I already used a lot!) to the client. Anyway, thanks again, you cleared me how the tag works.

o.t. Take a look here
What about that feature request? :)

Bloke · 2011-03-08 17:12:16

caruso_g wrote:

Offset is desc so last image added (in fact the second one I needed) was skipped, and first one was displayed.

Sure. But in case anyone is wondering why the sort popped up in my version, you’ll need it if you (or your client) put your images in a non-filename order inside the article image field.

Example: Assuming your articles were named this:

5: a.jpg
8: b.jpg
42: c.jpg
90: d.jpg

with article_image = 5, 42, 90, 8 your version will return image 8 (‘b’ is the second image in the list, i.e. at offset=1 when ordered a.jpg, b.jpg, c.jpg, d.jpg), but mine with the sort will return image 42 because it forces the order to remain as you put it in the article image. If the file names are in the same order alphabetically as the images are sequentially it makes this behaviour seem a little wonky if later on a new images is added (with a higher ID) that has a lower alphabetic name!

I want to limit as much as possible the use of custom fields

Look closer. It’s not a custom field, it’s the article image field which is retrived via the custom_field tag :-)

Textpattern CMS

Textpattern CMS support forum

#1 2011-03-08 16:32:57

How to get the second article image only?

#2 2011-03-08 16:48:33

Re: How to get the second article image only?

#3 2011-03-08 16:55:21

Re: How to get the second article image only?

#4 2011-03-08 17:03:27

Re: How to get the second article image only?

#5 2011-03-08 17:12:16

Re: How to get the second article image only?

Board footer