Thread: Attn PHP guys = Stupid $20 contest for stupid wannabe programmer
View Single Post
Old 01-24-2007, 12:27 AM  
mkx
Confirmed User
 
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
Quote:
Originally Posted by jMEGA View Post
$query = "SELECT SUM(total_income) FROM `db` WHERE payment_date='Jan' ORDER BY id DESC";

Payment date should *contain* "Jan" since this is how it is entered "04:55:21 Jan 19, 2007 PST"
mkx is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote