SELECT last entry

[donkeychoker]

Hi peeps.

I wonder is someone would kindly help me, I am a little bit stuck.

I have an html form which when submitted went to a php page that inputted the data into a db and also echoed out the input.
I was concerned about duplicate entries if someone pressed the refresh button and thanks to the good folk on here was advised to create a redirect when the submit was used. The form now goes to a php page that connects to the db then redirects to a thank you page.
This works fine but now I am struggling to input what they submitted onto the thank you page.
I am a complete novice but I understand I need to use SELECT,
but I cannot for the life of me figure out how to get their input.

I assume you would SELECT the last record but how?

"SELECT all fields from database FROM my table WHERE ????????"

Can anyone help

Many thx

[donkeychoker]

Just to clear up:
I can connect to the db ok just unsure about calling the last record or should I say the record they inputted

[devinemke]

i assume you are using mySQL. use [man]mysql_insert_id[/man] to get the last primary key value that was inserted and use this to build your query. or stick the form data in a session and use it on the thank you page.

[donkeychoker]

Thank you for your reply, I had only just finished writing the post 🆒
I will read though that link thanks. I have no idea about sessions, I don't even know what they are.
I guess it isn't as simple as I hoped it would be ie: WHERE id=last

😕
Thx again