Thread: Attn PHP guys = Stupid $20 contest for stupid wannabe programmer
View Single Post
Old 01-24-2007, 12:50 AM  
jMEGA
Confirmed User
 
Join Date: Oct 2005
Location: St. Louis, MO
Posts: 671
Quote:
Originally Posted by jMEGA View Post
$query = "SELECT SUM(total_income) FROM `db` WHERE payment_date='Jan' ORDER BY id DESC";
here

$query = "SELECT SUM(total_income) FROM `db` WHERE MONTH(payment_date)='01' ORDER BY id DESC";
__________________
Design | SEO | Photo / Video Editing
( ICQ 49354667 )
jMEGA is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote