Refresh and forms

[NCC1701]

I have a problem with my form, after pressing the submit button the form inserts the data entered into the database and clears the form and displays a confimation message at the bottom. The thing is if the user refreshes the page the exact same record is inserted again which is really annoying, how can i prevent this?

Im using an autoincrement field in my MySQL table that the data is inserted so it thinks its a new record when in actual fact its the same.

thanks

NCC1701

[drew010]

prior to insert,what you can do is a select to determine if identical information is in there. i.e. you can select the email and name or something like that, and if its in there already say, this info is already in the database, and if its not, then you can add it in.