Hi everyone, I am only new here and only relatively new to php/mysql.
I have had a script written for me that is an IPN (Instant Payment Notification) for PayPal, it is written in PHP.
Upon successful payment it is meant to run some mysql commands and same with if a refund is made. It is also meant to log all the transactions to a table in mysql. (I have created the 'transactions' table already also)
I have made the button and set everything up.
For some reason though, the sql tables remain unchanged after a successful payment.
I have checked my IPN History on PayPal and they seem to be coming up fine there with the right information but it is not putting any data in the 'transactions' table or updating anything in the 'listings' table.
I have attached the code, it would be greatly appreciated if anyone could help me out with finding the reason.
Please remember I am relatively new to all of this.
Thanks heaps!
Here is the code: ( I had to put it in a txt file on my web server because of the character limit here on the forum)
http://www.cargenie.com.au/ipnscript.txt
Thanks to everyone who tries to help 🙂