assigning display order

[Anon]

I'd like to assign a display order to images within a directory so that I can force the images to display in a specific order upon the click of a 'next' button. I only want one image to be displayed at a time and use the 'next' button to advance through the assigned order.

any help would be appreciated.
thanks

[cordex]

Database.
Store the locations of the pictures and an order number in a database. Then, select from that database. Your next button would just tell the program which picture to select next.

[Anon]

Hi Ben,
thanks for the quick reply. I'm new at PHP/mysql. so forgive this question but what would be an example of the href of the next button?

[cordex]

Well, let's say you know what image you are currently on. It's in the variable $imgnum_in. Okay?

$sel_st = "SELECT * FROM table WHERE imagenumber > $imgnum_in";
$sel_rs = mysql_query($sel_st);
$sel_ar = mysql_fetch_array($sel_st); // since we just want the image directly above, we don't place this in any kind of loop.

Now, $sel_ar[imagenumber] will contain the image number. Assuming you have set up your table correctly, that is.

-Ben

[cordex]

Oops, didn't look at your question well enough (I've seemed to do that lately).

$imgnum holds the next image to go to
If you want to use a link:
echo "<A href='http://www.mydomain.com/mydir/myscript.php?imgnum=$imgnum>Click here</a>";

If you want to use a button:
echo "
<form method=post action='http://www.mydomain.com/mydir/myscript.php'>
<input type=hidden name=imgnum value='$imgnum'>
<input type=submit value='Click Here'>
</form>