Limiting displayed results

[Anon]

I need to display images from a dir on a webpage. Ive managed to read the names of all the files in the dir, and load the names into an array. From there i can display all the images on one page. But i would like to limit it to ten images per page, with a next button the see the following pages. Thats my only problem. The loop that limits the images displayed, because as soon as there are less than 10 i get empty image boxes. If someone could post an example and this loop.

Thank you.

[alfoxy]

maybe try

SELECT * FROM news ORDER BY newsnr desc LILIT 1,10

this will give you 10 results from 1 up

[Anon]

he made a mistiake: not LILIT
but LIMIT :-)

[alfoxy]

thanks raffael3d, i spend more time debugging spelling mistakes than i do writing code maybe i should join DNA (National Dyslexia Association) ... ha ha

[Anon]

uhm.... its not in a database. They are just files in a directory. SQL wont help. Any other ideas?

Thanks.