image list help

[Anon]

can someone please help me out by telling me how to:

have a diretory called recent with images then have a script that will echo a list of links to the images. the list has to display the 10 most updated images and maybe have a next and previous links to see the next 10

if some one would help me out I'd be very thankful

[jc94062]

You'd have to order them by date in some form, I do this by a field called position, which is yymmddhhmmss, and then ORDER BY position DESC gives me the newest entries at the top, by simply updating this field when images are updated you'd get the list.

To just limit it to 10 or whatever, use LIMIT 0, 10 to display the first 10, I'm not sure on the exact specifics of this, (except that it goes into the SELECT statement of course) as I've personally never used it.

www.mysql.com should have more userful information on LIMIT.

[Anon]

I don't use a database I know that there is a way to do this without one. my whole problem is that I have enough php skills to do an echo! haha