Hi,

I use IPN to automatically process payments. On be it rare occasions, I sometimes do not get the IPN or I get the IPN but the database does not update. (ok computers are not 100% perfect). This means the customer does not get their membership authorized automatically whereupon I then have to authorize it by checking for the money and updating the databse manually. (not easy if you are in a bar at 00:01 hours and drinking beer!)

My idea is; should a customer complete payment, but the system doe not authorize them, the customer can use their TXN ID number and enter it into my system. The system would then be able to authorize them automatically. But to do this I think I need to use the PayPal API?

Upon the customer entering their TXN ID, I would like to query PayPal via the API to check for completed payment and also get some other data e.g. email and date-of-payment so the system can confirm the payment and update the database.

BUT! I have no experience using the API, although I am ok with PHP.

Anyone have any ideas? Is there already a script or similar available?

Thank you.

Rob