Topic: Payment per month

[zavin]

 I am wanting to get a total of all payment made in a month. For example June would = all payments made in June. My database has the following feilds:

Code: [Select]

payment_id, user_id, txn_id, item, payment_date, payment_status, payment_gross, payment_type, mcgross, quantity, payer_id, payer_status, payer_email, payer_businessname
The code I am using right now is:

Code: [Select]

$sql = "SELECT sum( mcgross ) AS `total` FROM `payments`WHERE DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= FROM_UNIXTIME(`payment_date`)";
$rs_result = mysql_query ($sql);
while ($row = mysql_fetch_assoc($rs_result))
echo "$".$row['total'].";
 Doing it this way only shows the last 30 days. Does anyone know of a good solution?

[Barand]

...WHERE MONTH(FROM_UNIXTIME(`payment_date`)) = 6

[zavin]

 Your response was not very clear. I tryed:

Code: [Select]

$sql = "SELECT sum( mcgross ) AS `total` FROM `payments`WHERE DATE_SUB(CURDATE(),INTERVAL 1 MONTH) WHERE MONTH(FROM_UNIXTIME(`payment_date`)) = 6";And:

Code: [Select]

$sql = "SELECT sum( mcgross ) AS `total` FROM `payments`WHERE DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= FROM_UNIXTIME(`payment_date`)WHERE MONTH(FROM_UNIXTIME(`payment_date`)) = 6";Neither of these gave me the results I was looking for. What exactly are you trying to tell me to replace?

[zavin]

 Can someone explain to me why a php question got moved to a database discussion? The database is working fine. I am having a problem getting the php coded correctly.