Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $first_minute = mktime(0, 0, 0, date("n"), 1);
- $last_minute = mktime(23, 59, 59, date("n"), date("t"));
- $select = mysql_query("SELECT * FROM `usr_payment_processing`
- WHERE `usr_id` = '$id' AND `status` != '1' AND `timestamp` > '$first_minute'
- AND `timestamp` < '$last_minute' SUM(price) AS totalprice");
- $payments = mysql_fetch_array($select);
- echo $payment['totalprice'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement