how to show the total sum of amount between the entered date(start date --- end date) selected by user

Question

enter image description here how i can calculate the total sum between particular date (eg: 2016/06/16 to 2016 enter image description here/08/17). and which the date will be choose by the user from front end. I have tried something like this.

    $sql = "select sum(amount_no) from tsurphus where subDate BETWEEN '2016-03-01' AND '2016-08-05'";
    $q = mysql_query($sql);
    $row = mysql_fetch_array($q);
    echo 'Current Total Amount. Rs: ' . $row[0];

But here the problem is that to calculate the total amount i need to change the date from code. please help.. thank in advance.

I don't understand the problem. Nor how the title relates to the content — Strawberry, Aug 19 '16 at 07:28
If I understand this correctly, your total is coming in currency Rs. Since you have different currencies, you want them to show total in USD, total in INR etc? — Indrasis Datta, Aug 19 '16 at 07:32
Are you looking for [binding](http://stackoverflow.com/questions/16612251/how-to-bind-multiple-parameters-to-mysqli-query) (and mysqli)? — Solarflare, Aug 19 '16 at 07:37
You can store date in `TIMESTAMP` format in database and retrieve in query in `date()` format here — Zain Farooq, Aug 19 '16 at 07:38
SELECT sum(id) FROM `tbl_users` where date_created between '2016-04-15 10:50:12' and '2016-04-17 10:50:12' worked for me — Rohit Dhiman, Aug 19 '16 at 07:40

score 1 · Answer 1 · answered Aug 19 '16 at 08:38

1

In your query, you should group by the currency field.

Considering your field name is "currency", try this:

$sql = "SELECT SUM(amount_no), currency FROM tsurphus WHERE subDate BETWEEN '2016-03-01' AND '2016-08-05' GROUP BY currency";

answered Aug 19 '16 at 08:38

Indrasis Datta

8,692
2
14
32

how to show the total sum of amount between the entered date(start date --- end date) selected by user

1 Answers1