Quote:
Originally Posted by mkx
Payment date should *contain* "Jan" since this is how it is entered "04:55:21 Jan 19, 2007 PST"
|
Assuming you've got your db connection established..
Quote:
|
Originally Posted by calmlikeabomb
$Total= mysql_result(mysql_query("SELECT SUM(total_income) AS Total FROM `db` WHERE payment_date LIKE '%Jan%'"),0);
print $Total;
|