I need to grab the ID of the next row

Kinsbane

Ok, I'm working on a client's site and he does photography. I've got the thumbs sorted out, and when you click one, it views it and there needs to be a link there that goes to the following row after the current one.

I need a dynamic way of doing this in case certain rows get removed from the DB completely so as not to break anything.

Right now I'm using this:

<a href="view.php?id=<?= $id+1; ?>">Next</a>

And would like a dynamic function to grab the row that follows the current one.

Thanks!

olaf

What is the problem? do you have everytime a photo?

Kinsbane

olaf wrote:
What is the problem? do you have everytime a photo?

no, because when the link is generated it takes the current row's ID # and increments by 1. this doesn't work well because there are some rows that're missing. For instance, if you're on row #20, the link would say to go to ID # 21, but if #21 is missing, a blank page comes up.

I need a way to detect the next physical row in the table, so as to avoid any missing rows & blank pages.

Thanks for any help!

olaf

Create the link only if the image exists.

if($row['the_image'] != "") { echo "<a href=\"".$row['the_image']."\">link label</a>"; }

Kinsbane

olaf wrote:
Create the link only if the image exists.

if($row['the_image'] != "") { echo "<a href=\"".$row['the_image']."\">link label</a>"; }

Well, how the program works is it's using the row's ID# from the database to pull up all the relevant info relating to that photograph - name, image URL, description, category. When a specific picture is browsed to, it uses the ID provided through $_GET to grab the row data for that ID.

So I don't need to check for the existance of a certain field being populated, I need to check for the next actual row in the table, and put that row's ID into the link so it's proper. It should only not display a link when it comes to the very last row in the table.

olaf

place a counter in your script and set the condition to

If ($counter < $numrows) { echo "bla"; }
$counter++;

you should use a session to transport the counter value