Sample code for a payment query on member_id --> 1 How do I get a list of payments in a date range ? PHP: <?php include("../config.inc.php"); $pl = array(); $dat = date('Y-m-d'); foreach ($db->get_user_payments(1, 0) as $p){ if (($p['begin_date']<=$dat) && ($p['expire_date']>=$dat)){ $pl[] = $p; foreach ($pl as $key => $value) { if(is_array($value)) { foreach ($value as $keyv => $valuev) { echo "$keyv => $valuev <br>"; } } } } } ?> Marcel http://businessletters.com http://01businesses.com
You may filter it in PHP code. $p['tm_added'] contains time of record addition (invoice creation) $p['tm_completed'] contains time when record was marked as paid;