Stop re-submit on form on page refresh

[leachus2002]

Hi All,

 

Is there any way that PHP can detect if a page has been refreshed? Basically I have a form that when submitted, inserts a row in to a database, but I am finding that when I refresh the page, it repeats the insert statement.

 

Any ideas?

 

Thanks

Matt

[litebearer]

Use INSERT IGNORE rather than INSERT. If a record doesn't duplicate an existing record, MySQL inserts it as usual. If the record is a duplicate, the IGNORE keyword tells MySQL to discard it silently without generating an error.

[leachus2002]

Hi There,

 

Unfortunately, this didnt work. Could this be cause I am using an identity column, thus not making the columns identical?

 

Cheers

Matt

[dragon_sa]

you could possible process the form on a seperate page then use the header function to return to your form

[redfort]

use some paramters to identify the submit and refresh ......it works............

[leachus2002]

Like the submit param's - can anyone prompt my memory?

 

Thanks

Matt

[litebearer]

Could this be cause I am using an identity column, thus not making the columns identical?

Please show your code and db structure