UBB.Developers Forums Community Development Programming PHP and Server-side Scripting How to stop POSTDATA from repeating?

I have a HTML form that calls a PHP script to enter data into a MySQL DB then displays the info to the page. However, it is human natuire for a person to REFRESH the page and this is re-submitting the data causing multiple entries. I tried adding

mysql_close();

at the end of the PHP script that is called from the HTML form but this isnt working. Would I add the mysql_close() function at the end of the HTML form to stop this?

michael

When the user hits refresh a new instance of the script is run and therefore you can't use something like that in the script.

You have to do something similar to what threads does, check if the data posted is already in the database and if so just inform the user that the info is already inserted.