Manually Cycle Through Database

ts10

Is there any way to manually cycle though something like a while loop where it displays the first result, then click next and it displays the second, etc?

Here's what I'm trying to do:

I have a query that pulls the location of a picture for an individual agent. Each agent may have many pictures, but I only want to show one at the time - the latest uploaded first.

So, I need to display the location of the first picture, then click next and it shows the second and so on.

I have brainstormed and am lost at how to do this.

Thanks!

bretticus

real quick...off the top of my head. I would create a database with URL columns, a submit date, and auto-incrementing ids.

On the page load I would check for $_GET['id'].

if I didn't get one I'd just shoot this at the database:

$sql = "SELECT id, url FROM photos ORDER BY submitdate DESC LIMIT 1";

to get the next link, I would send a query something like:

$sql = "SELECT id FROM photos WHERE id < $theidwegotabove 
ORDER BY submitdate DESC LIMIT 1";

That id would be set as my GET id value.

The following might get the previous link GET id:

$sql = "SELECT id FROM photos WHERE id > $theidwegotabove 
ORDER BY submitdate LIMIT 1";

Hope this helps you to conceptualize. It's not tested.

ts10

Ahh, that's interesting and might work!

I'll check that out and see what I can come up with.

Thanks!