Hi, I need to create a MySQL query that returns the number of failed credit card transactions in a given period of time. Which fields would I join on to do this, and what restrictions need to be placed in the WHERE clause? many thanks, andy_b
This can be done for rebills only. For all CC transactions you need to write php code that will get all payments and check each payment record to find an error if transaction was processed. For rebills you can use rebill_log table: select count(*) from amember_rebill_log where payment_date > '2010-01-01' and payment_date < '2010-01-01' and status <>0