Advertisement
Guest User

Untitled

a guest
Sep 27th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. $first_minute = mktime(0, 0, 0, date("n"), 1);
  2.  
  3. $last_minute = mktime(23, 59, 59, date("n"), date("t"));
  4.  
  5. $select = mysql_query("SELECT * FROM `usr_payment_processing`
  6. WHERE `usr_id` = '$id' AND `status` != '1' AND `timestamp` > '$first_minute'
  7. AND `timestamp` < '$last_minute' SUM(price) AS totalprice");
  8. $payments = mysql_fetch_array($select);
  9.  
  10. echo $payment['totalprice'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement