Code: Select all
<?php
$query = "select ID, source, finalPayment, salesPerson1 from Invoice where salesPerson1 > 1 and finalPayment != 0 and finalPaymentDate between $month and $nextMonth";
?>finalPaymentDate is being stored as a timestamp number in the database