How to get the URL of displayimage.php?album=$1&pos=$2 ?

[antisa33]

Hello
I would like to know what is the sql line to obtain the link of the picture displayimage.php?album=$1&pos=$2
Thanks

[Joachim Müller]

That's a relative link that doesn't point to a particular image, but just to the position within a particular album. That position may change. You can't come up with a query that represents the URL snippet you posted that points to a particular pic.

[antisa33]

How can i do ?
This is to have the last uploads, i have recreated a page because the lastup didn't do what i wanted   

[Joachim Müller]

So your actual question if "how do I create a meta album that actually displays the last upload images instead of the last updated albums"? Is that correct?

[antisa33]

My question is : i can display now a page with the last picture uploaded.
But when i clic on the title, i dont know what "a href" to put on.
You can see the page i created here
http://www.coloriage-educatif.com/soutien_scolaire_dernieres_fiches.php
All is ok but not the link on the title  :-\
I have done like this because i didn't know how to modify the template for the normal "last upload" to have a result like the link i give to you.
Thanks a lot for your replies

[Joachim Müller]

That's not a coppermine-driven page as far as I can tell.

You're using cpg1.4.10, while the most recent stable release currently is cpg1.4.19, so you're running 9 versions behind. Instead of trying to figure out how to come up with a custom query I suggest that you upgrade asap for security reasons - what good is a custom query page if your gallery get's hacked, especially with kids as target users?

[antisa33]

thanks i will update it but i dont know how to do with my link problem 

[Joachim Müller]

What link problem?

[antisa33]

This one   :-\

But when i clic on the title, i dont know what "a href" to put on.

[antisa33]

nobody can help me ?
all my script is finished, i just have this problem 

[antisa33]

nobody can tell me how can i add a link, or how can i do to modify the lastup thumbnails view (add the category+album name ) ?