Preventing Variables From Passing On Refresh

[The_PHP_Newb]

How can I prevent a database insert from occuring twice if my user clicks the refresh button on their browser?

I cannot simply forward the user to another page after the insert happens and I can't change this fact.

Any help is appreciated.

Jim

[DeltaRho2K]

Run a select query before your insert query to see if the value exists already:

$qrycheck = mysql_query("SELECT * FROM table WHERE field1 = '$variable1passed' AND field2 = '$variable2passed'");
$qrycount = mysql_num_rows($qrycheck);

If ($qrycount != '0'):
// Put some message here to let the user know it already exists

Else:
// Do your insert query here...


Endif;