I have a submit button that processes a sql insert statement. How do I prevent the statment from resubmitting itself when the user refreshes the page with either an F5 or with the IE refresh option?

The simplest solution is to make it submit to another page, and then redirect to the first page.

Otherwise, you can check to see if an identical row already exists in the database and only enter a row if there isn't.

HTH,

Snib

<><

If the row has a unique id, place that unique id in a session variable.

if (!isset($_SESSION['this_form_name_is_submitted']))
{
  // do form processing
  // insert query
  $_SESSION['this_form_name_is_submitted'] = mysql_insert_id();
}
else
{
  // you already submitted!
}

That's the easiest way I could think to do it. Of course you don't have to use the insert id at all, a simple boolean will do, but that might have other useful applications.


Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail