Major Help Needed.

[Anon]

Thanks to anyone in advance for taking the time to read this.

I am having trouble trying to get something to work.

What I am trying to do is, once a record is removed from the mysql database, I want the page to redirect back to the main page and bring up the next record...

Here's what I mean:

I have a page called results with ALL the entries from my database listed. Lets say I click the delete link I have made for a record with the ID of 10:

<a href='delete.php?id=$id' onclick=\"return confirm('Are you sure?');\"><font face=verdana size=1>Delete</font></a>

Now after I click the alert and say yes that I want to remove it, I am directed to delete.php where it is removed...

Now, I want delete.php to automatically send back to the results page with ALL the database entries but instead of starting me off a the top again, I would like it to put me at the record with ID 11.

How would I do this?

Thanks,

Jeff

[toma42]

header("Location: results.php?id=" . ++$id);

[Anon]

Hoping I have understood your question correctly Jeff:

When you redirect from delete - say with header("location:..."); - you can send across an anchor link:

header("location: page.php#11");

The anchors can be generated fairly easily along with the results when you output the html, and the reference can be calculated depending on the ID deleted.

Hope this helps a bit.

-m.

[Anon]

I love you guys 🙂

[lentin64]

I think you made a mistake, Tom.

$num = $id+1;
header("Location: results.php?id=".$num);