Hey i kinda posted this before, someone posted back saying they'd PM me and never did, so the thread died. Anyway..

I had a database of pictures - they're for touring a property on a real estate site

the pictures get uploaded in records which contain 5 pictures, so i have id,groupname,file1,file2,file3,file4,file5,propert yid

so then i query saying give me all the results where propertyid = $this

so.... I get "living room" followed by 5 thumbnails, then "bathroom" followed by 5 thumbnails etc. When you click on the thumbnails the main image changes.

My question is: how can i make previous and next buttons for something like this, basically it will have to first get the record, then move through the files 1-5 and then next record. I want the user interface to be seemless to the user just clicks next next next and it will gop through the pictures in order.


thanks!

so.... I get "living room" followed by 5 thumbnails, then "bathroom" followed by 5 thumbnails etc. When you click on the thumbnails the main image changes.

This will require JavaScript.

My question is: how can i make previous and next buttons for something like this, basically it will have to first get the record, then move through the files 1-5 and then next record. I want the user interface to be seemless to the user just clicks next next next and it will gop through the pictures in order.

I don't quite get what you're trying to do right here, please try to explain better.

right... I already got the javascript in there working. Basically what i'm trying to do is easily navigate through all the pictures with "next" and "previous" buttons. The problem being, instead of one picture per record (row) I have 5 pictures per row. So, let's say I run a query asking for all the slideshow records which belong to a certain property. This will load a row like "bedroom" which contains 5 image columns, then a row called "bathroom" that also contains 5 image columns. So, I'm trying to get a next button that will just go through all the pictures. I'm guessing that I need to make some sort of array containing each filename and have the button move through the array. The only problem is: i have no idea how to do this.

milomedia,

Are you indicating that you don't mind if the screen refreshes after hitting 'Next?' If that's the case, then you can do the initial pull to identify which primary keys are the photos you wish to display. You could either store that in the session or you could POST it from screen to screen using an <input type="hidden"> field. Then use your 'Next' and 'Previous' buttons to keep track which of those images you are currently displaying. So let's say your list of images to display for the bedroom are 455,456,461,467,475 (primary keys out of your image table).

Then your URL could look something like this:

displayPicture?list=455,456,461,467,475&displaying =456

Here, your logic would pick apart the list and see that you have 5 images to display and that you are currently displaying the 2nd in a series of 5. From that, you could derive the logic to display or not to display the next/previous buttons (e.g., if you were displaying 455, then no previous button).

Is this close to what you are asking for?

Sorry, I'm not in a place where I can write and test code right now, but let me know how this satisfies your problem.

oh sweet, thanks! That seems like it'll work. I'll let you know after I try to implement this. Thanks again.
-e

Ok so i wasn't having much luck with the above way, so i did this,

I collected all of the filename for all of the pictures for any given tour and put them in an array falled $filenames, so to display the main picture i use $filenames[0] as the source.

So now for the next button i just need to do filenames[1] etc etc etc.. However, because I'm not reloading the page (because the picture changes via javascript) I really have no way of buming up the array each time the page loads.

So now the conundrum is trying to get a next button that changes value each time it is clicked.

Think I'm barking up the right tree?

hey heya, btw I got this to work... not EXACTLY how I wanted, but it works! Case closed, thanks to all you guys who put in in put

milo,

I'm glad to hear that you finally reached a resolution. WHEW! At the end of the day, it's nice to get things done, isn't it?

if the day ever ends, lol.

thanks again