Need an idea....

[Anon]

Hi !

I've a little coding prob and no idea how to solve it. Perhaps someone could give me a little hint? ;o)

I want to make an image gallery with different dynamic categories. All infos (categories and image-infos) are stored in a mysql-database.

I have 3 php-files:
1. index.php - shows all categories
2. showcat.php - shows the images of the cat chosen.
3. showimg.php - shows the image and infos

So far - so good. ;o)

My problem is the "previous" and "next" button on the showimg-page. On the showimg-page I know the ID of the current image but not the ID's of the previous and the next image.

Would be no problem if the images are displayed ordered by their ID, but they are ordered by date (Y-m-d) added.

And the next problem is how to find out, when the is a "page break" on the showcat-page, when sliding through the images on showimg.php. (For the link back to the showcat.php.)

Hope someone understands my prob and could give me a little support...

thx
Petra

[Anon]

Hello,

Try this. Loop thru the DB and get all the ID's order by id. Then use that array to make the buttons.

Bill

[Anon]

wouldn't it be possible to make a mysql query like this
... WHERE cat = 'blabla' ORDER BY date ...
in the showcat.php + showimg.php files.
you'll get a resultset ordered by dates and you can walk through it with foreach...
and in the showimg.php mußt du mit foreach bis zum aktuellen bild vorrücken und noch eins weiter, und die id des "weiteren" bildes für den next-button verwenden (analog dazu den previous-button)
oder so irgendwie. naja ich weiß auch nicht so genau

[Anon]

Das ist eigentlich genau das, was ich vermeiden wollte. Denn je nachdem wieviel in der Datenbank ist, könnte das dauern und auch unnötigen DB-Traffic erzeugen.

Aber ne andere Idee hab ich leider auch nicht...

Thx!