Form Resubmits SQL on Reload

[Cynthia_Blue]

I'm building a form with a submit button in PHP. When the button is pressed, I use $PHP_SELF to go to the same page, and use an IF statement to see if there is a value in the button's name variable. If so, the button has been pressed and the SQL under that if is excecuted. If not, the form itself is displayed.

However, after pressing the button, and when I'm on the page that has executed the SQL (in this case adding an entry to the database), if I click the Refresh button the browser, the same SQL statement is executed. I assume this is because there is still a value in the button's name variable.

Is there any way to get away from this? I'd like a Browser Refresh to clear out that variable and bring me (or the user) back to the else statement with no value in that button.

Thanks. 🙂

[mystrymaster]

I don't know but I would think NO as what you are doing when you click refresh is simply sending the last request you sent to the server again and since your last request was a form submission wiuth that variable declared it would send it again.

[Cynthia_Blue]

Hmm I was hoping there was maybe a flush or something to clear the variables after the SQL query executes... I looked over PHP.net but didn't find anything that made sense... :p

[mystrymaster]

there might be but I am not sure - I'll look around as well