[Resolved] Stopping Refresh and Double Inserts..

[phence]

Right now i am using paypal's IPN... and when i get the completed responce back from paypal I insert data in my DB...

How can i stop the user from refreshing the page and therefore resulting in duplicate records... etc..

Thanks...

[drew010]

do a check before the insert making sure data doesnt already exists. perhaps use a unique value like txn_id that the ipn sends back. after your select, if mysql_num_rows is > 0, then the person has already been added to the db, and you shouldnt do another insert.

[phence]

Thats a good idea... You know what else i thought to do too is make sure i destroy all the session variables too!

Thanks, i should have thought of that!