I really didn't expect it to be as simple as using only an insert or update.
That being said, I can still send a successful payment, however I am still unable to insert a new record. Could you see what I have missed or done wrong in the attached listener.php page. I am guessing that I can leave the rowID column blank and let the DB create a new one and treat the other columns like I normally would like the payment date could just be a timestamp.
I don't know what else I am missing or have wrong. I tried changing these lines to this thinking maybe I had it wrong:
$InsertQuery->bindColumn("lotNumber", "i", "lotNumber", "WA_DEFAULT");
$InsertQuery->bindColumn("duesAmtPaid", "i", "duesAmtPaid", "WA_DEFAULT");
$InsertQuery->bindColumn("duesStatus", "s", "duesStatus", "WA_DEFAULT");
But still no new records inserted.
Also, I left the InsertGoTo blank thinking that the PayPal would direct to the success page, it does, but the user has to click the return to merchant button. This shouldn't matter correct?
Hopefully you can spot it easily. otherwise we can plan a screen share soon.